Bug #34992 Add option to SELECT column names INTO OUTFILE

Submitted: 3 Mar 2008 8:30 Modified: 17 Mar 2008 12:03
Reporter: Hans Ginzel Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:5.0, 5.1, 6.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: SELECT INTO OUTFILE "column names"

[3 Mar 2008 8:30] Hans Ginzel
Description:
Please, add an option to export column headers for SELECT ... INTO OUTFILE command.

It would be much more constructive then fidling with INFORMATION_SCHEMA.

http://lists.mysql.com/mysql/195450

How to repeat:
SELECT *
FROM   some_table
INTO   OUTFILE 'test_outfile.txt'

Suggested fix:
WITH COLUMN_NAMES

OR

WITH HEADER_LINE

There is a need for this.
[17 Mar 2008 12:03] Susanne Ebrecht
Hello Hans,

many thanks for writing a feature request.
The idea of you isn't sql standard conform but I think as an option this could be a possibility.
[26 Jan 2010 8:33] Valeriy Kravchuk
Bug #50612 was marked as a duplicate of this one.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.