mysql-error-1136

MySQL: Multiple Inserts for a single column

I'm looking for a way to do multiple row inserts when I'm only inserting data for a single column. Here is the example table: +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | id | tinyint(4...

Why does this MySQL query give "error 1136" when inserting values into table

Query: INSERT INTO Customer2 VALUES (1, 'Mrs','Jill','Hill','2 Step St','Hillington','Uxbridge', 'Middx''UB10 8XY','020 8999 684') ; ...