no, it'll save it in the data directory of the database only, reason is mysql doesn't have permission to write to any other directory.
"full path and file name" could be just file name like "data.txt" or full path of that directory like "/var/lib/mysql/db_name/data.txt" Nitin ----- Original Message ----- From: "Pey Ling" <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 3:31 PM Subject: Re: please help out > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
