mysql 数据迁移命令 备份database库table表中id大于22的数据,SQL如下
mysqldump -u test -ptest database table --default-character-set=gbk -t --where="id>22" >c:\test.sql
将年龄大于三十的同学的信息备份出来
mysql> select * from students where Age > 30 into outfile ‘/tmp/stud.txt' ;
mysql> load data infile '/tmp/stud.txt' into table students;