MySQL Forums
Forum List  »  Newbie

Re: INSERT INTO SELECT * column error in SQL code
Posted by: Peter Brawley
Date: November 24, 2018 07:18PM

> SQL won't parse row data into the sixteen columns

SQL has no psychic abilities, has to be told exactly what each column value is.

In your dta string it appears tht each column value is delimited by a semicolon. If that's so and if there are multiple such strings, you might find it convenient to use Load Data Infile to import the data, see the manual page for that cmd.



Edited 1 time(s). Last edit at 11/24/2018 07:18PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: INSERT INTO SELECT * column error in SQL code
November 24, 2018 07:18PM


Sorry, you can't reply to this topic. It has been closed.

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.