INSERT INTO targetTable
SELECT col_1, col_5, col_28, col_71
FROM intermediateTABLE
Ferhat BINGOL wrote:
Hi,
I have a 72 fields data txt file and I was inserting all data previously
but now I need only some of them to dump into the table.
I would like to select only 4 fields which are the 1st, 5th,28th and
71st fields.
Is there a statement to do that.
I have read http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html but could not find it...
Thanks...
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]