Hi, how to write this :"full path and file name"? can i copy it to my local pc rather than the server?
best regards, Pey Ling From: "Nitin" <[EMAIL PROTECTED]> To: "Pey Ling" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 5:09 PM Subject: Re: please help out > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
