mysql導(dǎo)出表數(shù)據(jù),mysqlworkbench怎么導(dǎo)出sql語句?
1. 在MySQL WorkBench的Server Administrator中雙擊要連接的數(shù)據(jù)庫;
2. 點(diǎn)擊左邊的Data Export,在右邊的數(shù)據(jù)庫列表中選擇要導(dǎo)出的數(shù)據(jù)庫;
3. Export to Dump Project Folder是每張表導(dǎo)出一個(gè).sql文件,Export to Self-Contained File是整個(gè)數(shù)據(jù)庫導(dǎo)出一個(gè).sql文件,這里選擇Export to Self-Contained File,選擇.sql文件保存路徑,下面還有是否導(dǎo)出存儲(chǔ)過程,是否忽略數(shù)據(jù)等選項(xiàng);