# [EMAIL PROTECTED] / 2003-06-21 12:35:04 -0700:
I'm trying to load a couple tons of data into a shopping cart system
and for some reason it keeps kicking back with an error. I'm too dumb
to figure out why. Can anyone tell me what's wrong with this code and
why it doesn't work?
I can
Try explicitly stating the columns you're inserting to (IE, INSERT INTO
products (quantity, model, image, etc.)), and not inserting a value for the
products_id. If it's auto_increment, the DB sets the value for you.
Cassidy
NETPACQ Systems, Inc.
Full Service Web Media
5205 Kearny Villa Way,
Hi
You need nothing or backtics - ` - around the table name - you have quotes
INSERT INTO products VALUES (153328, 2, '181150', 'noimage.gif', '154.1000',
'2003-06-20 23:03:00', NULL, '-00-00 00:00:00', '0.00', 1, 1, 1, 0);
also better to state the field names - if you add or remove a field