开发者

mysqldump limit records in between

开发者 https://www.devze.com 2023-03-28 12:50 出处:网络
mysqldump --opt --where=\"true LIMIT 100\" dbname > dbname.sql but what if I want rec开发者_StackOverflow中文版ords from row 2000 to 3000 ?
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

精彩评论

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