At 14:12 -0600 3/6/06, Ariel Sánchez Mora wrote:
When using select into outfile, I can only get
the table data, but I can't find how to include
the column names. I haven't been able to include
the column names into the actual return of the
query, and they don't get stored in the .csv
Anyone know how to include the column names,
table name, other info, as an actual answer from
MySQL? I realize that when I use the command
line I can see the column names, but this is not
the case when using, for example, Delphi, and my
real problem, when the outfile is made.
I use SQLyog for exporting to csv and they do
include the columns, my bet is its some SQL
option. The manual doesn't specify, at least in
the select syntax part.
There is no option. INTO OUTFILE dumps only data, not metadata.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]