MySQL 导出指定行数的语句

发表评论
1,475

A+

所属分类：Basic

$ /usr/local/mysql/bin/mysqldump -uroot -p'' database table --where="true limit 1000" > /tmp/a.sql
Enter password:
$ /usr/local/mysql/bin/mysqldump -uroot -p'' database table --where="id < 2052001" > /tmp/a.sql
Enter password:
mysqldump -uroot -p  -h192.168.11.18 database-name --where="true limit 100" > /root/db.sql
> select * FROM 表名 WHERE id > 24148614 and id < 24148619  into outfile  "/tmp/ab.sql" ;    #update mysql.user set File_priv=’Y’ where user=’xxxx’;

$ /usr/local/mysql/bin/mysqldump -uroot -p'' database table --where="true limit 1000" > /tmp/a.sql

Enter password:

$ /usr/local/mysql/bin/mysqldump -uroot -p'' database table --where="id < 2052001" > /tmp/a.sql

Enter password:

mysqldump -uroot -p -h192.168.11.18 database-name --where="true limit 100" > /root/db.sql

> select * FROM 表名 WHERE id > 24148614 and id < 24148619 into outfile "/tmp/ab.sql" ; #update mysql.user set File_priv=’Y’ where user=’xxxx’;

发表评论取消回复