Easy, use:'select * INTO OUTFILE "full path and file name" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" from user where race='chinese' and state='US'Nitin----- Original Message ----- From: "Pey Ling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 1:51 PM Subject: please help out
Dear all, Hi, i have a database called 'admin' and a table called 'user'. Inside table 'user', there are a lot of fields, i.e: name, email, race, state, and etc. There are totally 100000 records. When I wrote the sql query 'select * from user where race='chinese' and state='US''. It shows me more than 1000 results. Now, how can I save only these 1000++ data into a file in my pc? Please help out. Thanks. best regards, Pey Ling -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
