MySQL Forums
Forum List  »  Newbie

INSERT INTO SELECT * column error in SQL code
Posted by: Brad Tuttle
Date: November 24, 2018 04:34PM

Inserting table data rows into 'users' table within same dbse in phpmyadmin 4.7.7.

Insert data is one column of delimited data. No header but CSV export inserted a line 0;;;;;;NULL;"0";"0";"0";"0";NULL;;"0";;NULL

SQL won't parse row data into the sixteen columns in target table 'drup_users'.

INSERT INTO drup_users (col1, col2, col3)
SELECT * FROM kweggs_195

#1136 - Column count doesn't match value count at row 1

Options: ReplyQuote

Written By
INSERT INTO SELECT * column error in SQL code
November 24, 2018 04:34PM

Sorry, only registered users may post in this forum.

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.