比較兩個資料表不同部分

 比較兩個資料表不同部分

在t2表而不在t1表的資料

1、SELECT * FROM t2 WHERE id NOT IN (SELECT id FROM t1);

2、SELECT * FROM t2 WHERE NOT EXISTS(SELECT * FROM t1 WHERE t1.id=t2.id);

3、SELECT t2.* FROM t2 LEFT JOIN t1 ON t2.id=t1.id WHERE t1.id is null;

mysql 5 使用者網頁式中文手冊

請參考來源:mysql 5 | mysql 5 使用者手冊
--
真方便,都做成索引了! 值得收藏~~以備所需!

備份Mysql資料庫的指令

假設帳號 abc 密碼 1234
要備份的資料庫 my01 my02

D:\AppServ\mysql\bin\mysqladmin.exe -uabc -p1234 flush-logs
D:\AppServ\mysql\bin\mysqldump.exe my01 -uabc -p1234 --opt > my01.sql
D:\AppServ\mysql\bin\mysqldump.exe my02 -uabc -p1234 --opt > my02.sql

在windows下定期制作備份mysql的指令碼

參考來源
---
程式碼:--------------------------------------------------------------------------------
Dim fName,tNow,CMD
tNow = Now()
fName = Year(tNow) & FormatNumber(Month(tNow)/100,2,false) & FormatNumber(Day(tNow)/100,2,false) & FormatDateTime(tNow,3)
fName = Replace(Replace(fName,".",""),":","")
CMD = ""
CMD = CMD & "c:" & vbCrLf
CMD = CMD & "cd c:\mysql\bin" & vbCrLf
CMD = CMD & "mysqldump -u root -p""password"" vbb>d:\bbsbak\backup" & fName & ".sql"
Dim FileObject,BatFile,BatPath
Set FileObject = CreateObject("Scripting.FileSystemObject")
BatPath = "d:\bbsbak\backup.bat"
Set BatFile = FileObject.CreateTextFile(BatPath, True)
BatFile.WriteLine(CMD)
BatFile.Close
Set BatFile = Nothing
Set FileObject = Nothing
Set WshShell = CreateObject("Wscript.Shell")
WshShell.Run BatPath,1,true
Set WshShell = Nothing
--------------------------------------------------------------------------------


把以上程式碼存為backup.vbs,然後你用windows內已含有計劃工作來實現制作備份就行

--opt

制作備份的時候要加上這個參數.....恢復的時候就方便了...對比一下產生的dump文件就會發現增加了那些了...

恢復很簡單...

mysql -u root -p dbname

然後會提示你密碼...