Hello All,
How can I dump selected rows into a file (using a query or mysqldump)?
i.e, I want to dump only the rows of this query: SELECT * FROM tbl WHERE id>100 AND id<200;
mysqldump --help shows that it takes a --where / -w option.
So:
mysqldump -w "id>100 and id <200" db_name tbl_name
might do the job.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
