怎样使用 SELECT…INTO OUTFILE 语句,备份 booksale 数据库中的所有表的数据到C:\bakup 目录中,要求每个表的数据单独存储。
mysql> use booksale
mysql> select * from books into outfile 'c:/bakup/data_books.txt';
mysql> select * from categories into outfile 'c:/bakup/data_categories.txt';
mysql> select * from comments into outfile 'c:/bakup/data_comments.txt';