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

[anggwaponi]

hello all

i would like to ask our moderators, as well, my fellow guest in here about the message i got after i issued a command.

the scenario is i'm trying to insert data to an existing table but i got a result that says:


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


and this is the command i have issued in the Run SQL query/queries:


INSERT INTO notes (
`phone`
)
VALUES ( 72091, 73321, 73378, 112717)


what is probably the cause of the error? and what is the right command i'm going to issue?


cheers! ;->

[ChaosOrb]

in your notes table, you specified one column only named 'phone', yet the number of columns you inserted in the VALUES does not match the number columns in the table.

insert them 1 by 1 if yo are to insert that many.

[anggwaponi]

in your notes table, you specified one column only named 'phone', yet the number of columns you inserted in the VALUES does not match the number columns in the table.

insert them 1 by 1 if yo are to insert that many.

hi ChaosOrb ..

is their such a way i can do it then using only 1-parenthesis () separated only with comma (,)?

i mean its gonna be very tiresome if i'll input it individually. good thing if its only like less than 10 numbers. but i'm sure come a time that above 10 numbers will be inputted into the systems.


hoping to be assisted than ..


cheers!

[cold_fusion]

Depends on your SQL database, you could do the batch inserts like this:

INSERT INTO notes (`phone`)
VALUES ( 72091), (73321), (73378), (112717)

[moz_k2]

is their such a way i can do it then using only 1-parenthesis () separated only with comma (,)?

i mean its gonna be very tiresome if i'll input it individually. good thing if its only like less than 10 numbers. but i'm sure come a time that above 10 numbers will be inputted into the systems.

Are you trying to say you want to add multiple rows with one insert statement?

if sql server imo gamit pwede ani lang

INSERT INTO notes(phone)
SELECT 72091
UNION
SELECT 73321
UNION
SELECT 73778
UNION 
SELECT 11271

kung dli gani pwede rka mag specify ug "from" na keyword
Tested this on oracle.

INSERT INTO notes(phone)
SELECT 72091 FROM notes
UNION
SELECT 73321 FROM notes
UNION
SELECT 73778 FROM notes
UNION 
SELECT 11271  FROM notes

Depending on what db your using some have different ways of supporting multiple row insert.