Issue while inserting multiple rows in one MySQL column- PHP

Question

The query syntax is as follows:

INSERT INTO sent (username,password) VALUES 
 ('user','user2','user3','user4','user5','user6'),
 ('pass','pass2','pass3','pass4','pass5','pass6')

Resource: http://dev.mysql.com/doc/refman/5.5/en/insert.html

The mysql_error() always showing me this:

Column count doesn't match value count at row 1

I have no idea what should I do. Now it's time to ask you about this.

In this case I have to insert in each column 6 values, and I have two columns to operate. — L'algerien
– L'algerien, Commented Jun 15, 2014 at 23:03
You need to format it as INSERT INTO table (field1,field2) VALUES ('user', 'pass'),('user2','pass2') and so on — andrewsi
– andrewsi, Commented Jun 15, 2014 at 23:04

Gergo Erdosi · Accepted Answer · 2014-06-15 23:04:26Z

2

You specified 2 columns with 6 values. The number of columns and values has to match. What you want is this:

INSERT INTO sent (username,password) VALUES ('user','pass'),('user2','pass2'),('user3','pass3'),('user4','pass4'),('user5','pass5'),('user6','pass6')

See the MySQL documentation for more details:

INSERT statements that use VALUES syntax can insert multiple rows. To do this, include multiple lists of column values, each enclosed within parentheses and separated by commas. Example:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

answered Jun 15, 2014 at 23:04

Gergo Erdosi

42.3k21 gold badges122 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Issue while inserting multiple rows in one MySQL column- PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related