Can anyone help me find an error in this query please, I am trying to insert multiple rows at once but the blimming thing won't let me, saying the SQL command is not properly ended!! I am going mad here. Thanks for saving my sanity.
Please see the example in the code snippet.
INSERT INTO customer(
custid, firstname, lastname, houseno, street, city, postcode, telnum, email, county
) VALUES (
100012, 'Sergio', 'Fish', '34', 'Johny Walker Av', 'Kingston', 'K2 5OP', '02080987456', 'walkerJohn@bt.com', 'surrey'
) , (
100013, 'Georg', 'Hanz', '12', 'Fishmongers Lane', 'Brighton', 'B2 0YU', '01940123456', 'firstname.lastname@example.org', 'Kent');