LinusIT - 5:41 pm on Jan 27, 2011 (gmt 0)

The first insert script worked fine, it's the second one that's entering two values that doesn't work.

They are quotes, not backticks.

Should the insert script be something like:

INSERT INTO 'model' ('manufacturer_id', 'model_name') VALUES (1, '145'), (1, '146'), (1, '147'), (1, '155');

So the smallint field doesn't have any quotes but the varchar field does.