Hi,
i am using mysql 4.0.0 version -alpha in windows 2000.
i'd like to export the mysql table data to excel format.
So,i use the outfile method.
mysql>select * into outfile 'backup.xls' from <tablename>;
When i open 'backup.xls' in microsoft excel,i can view all the data ,but i
can't view the field name.
Is there any method to export the field name together when i use outfile
method?
Tq.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to