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
精彩评论