If you are windows then I prefer to use SQLyog at http://www.webyog.com to do the job.
ITS FREE! Karam --- "Homam S.A." <[EMAIL PROTECTED]> wrote: > NOTE: I sent this message yesterday, but for some > reason it didn't show up in the list. If you've > already received it, I apologize for the > inconvenience. > > So here it goes again: > > > > > I searched the online manual and all I could find > was > a reference to a statement of the form: > > SELECT INTO OUTFILE... > > http://dev.mysql.com/doc/mysql/en/ansi-diff-select-into-table.html > > I searched for this statement on the web and I found > several references to a statement that should look > like this: > > select * into outfile 'C:/MyOutfile.txt' > fields terminated by ',' > lines terimated by '|' > from myTable > > This statement generates a syntax error on MySQL > 4.1.9. The following variation also generates a > syntax > error: > > select * from table into outfile 'C:/MyOutfile.txt' > fields terminated by ',' > lines terimated by '|' > from myTable > > Why is this statement rejected? Why is it not > documented anywhere in the manual except for a > passing > reference? > > And if there's no such a statement, how come there > are > many references to it on the web that date back to > MySQL versions older than 4.1.9? > > Finally, if this statement has been > depricated/removed > from 4.1.9, is there any way to export a table to a > CSV file? > > Thanks, > > Homam > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
