Something like that: SELECT ----- INTO OUTFILE '<filename>' FROM Table etc etc ;
Marcelo Araujo On Wednesday 25 February 2004 21:50, Lorderon wrote: > 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; > > > thanks in advance, > -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]