1.
mysql> use dbname
Database Changed
mysql> select * from driver into outfile 'a.txt';
2.
C:\>mysqldump buybook > d:/mysqlbak/buybook.sql
或者
C:\>mysqldump buybook > d:/mysqlbak/buybook.txt
建议用2
mysql> use dbname
Database Changed
mysql> select * from driver into outfile 'a.txt';
2.
C:\>mysqldump buybook > d:/mysqlbak/buybook.sql
或者
C:\>mysqldump buybook > d:/mysqlbak/buybook.txt
建议用2
如只要纪录的话:
select * into outfile 'filename.txt' from tablname;