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

Question

Query:

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

Answer 1

From the little details you gave, this is how that query should look like:

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

You're missing a comma between Middx and UB10