Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Insert script failing


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


OK, 5 minutes later, on the next step and I'm stuck again. Damn...

I'm not trying to add data to the "model" database using the following:

INSERT INTO 'model' ('manufacturer_id', 'model_name') VALUES ('1', '145'), ('1', '146'), ('1', '147'), ('1', '155'), ('1', '156'), ('1', '159'), ('1', '164'), ('1', '166'), ('1', '33'), ('1', '75'), ('1', '90'), ('1', 'Sprint'), ('1', 'Arna'), ('1', 'Brera'), ('1', 'Giulietta'), ('1', 'GT'), ('1', 'GTV'), ('1', 'Mito'), ('1', 'Spider'), ('1', 'SZ');


I can't see where the problem is, I'm getting failed : You have an error in your SQL syntax; errror message. Once I've got the above code working, I'll be able to do all the other manufacturers.

Thanks


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4251919.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com