开发者

mysqldump limit records in between

mysqldump --opt --where="true LIMIT 100" dbname > dbname.sql

but what if I want rec开发者_StackOverflow中文版ords from row 2000 to 3000 ? like in general sql we can use LIMIT 2000, 3000; but is there any similar alterntative for mysqldump ?


there --where seems like sql injection prompt,
however is handy

mysqldump --opt --where="1 ORDER BY id LIMIT 2000, 1000" dbname > dbname.sql
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜