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, '0000-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 this query will throw an error INSERT INTO `products` (`products_id` , `products_quantity` , `products_model` , `products_image` , `products_price` , `products_date_added` , `products_last_modified` , `products_date_available` , `products_weight` , `products_status` , `products_tax_class_id` , `manufacturers_id` , `products_ordered` ) VALUES ( 1153328 , 2 , '181150' , 'xx' , '152.3350' , '2003-06-20 11:11:11' , '0000-00-00 00:00:00' , '0000-00-00 00:00:00' , '0.00' , 1 , 1 , 1 , 0) HTH Peter -----Original Message----- From: Dan Bowkley [mailto:[EMAIL PROTECTED] Sent: 21 June 2003 20:35 To: [EMAIL PROTECTED] Subject: why me??! 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? INSERT INTO 'products' VALUES (153328, 2, '181150', 'noimage.gif', '154.1000', '2003-06-20 23:03:00', NULL, '0000-00-00 00:00:00', '0.00', 1, 1, 1, 0); The table itself looks like this CREATE TABLE `products` ( `products_id` int(11) NOT NULL auto_increment, `products_quantity` int(4) NOT NULL default '0', `products_model` varchar(12) default NULL, `products_image` varchar(64) default NULL, `products_price` decimal(15,4) NOT NULL default '0.0000', `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00', `products_last_modified` datetime default NULL, `products_date_available` datetime default NULL, `products_weight` decimal(5,2) NOT NULL default '0.00', `products_status` tinyint(1) NOT NULL default '0', `products_tax_class_id` int(11) NOT NULL default '0', `manufacturers_id` int(11) default NULL, `products_ordered` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`), KEY `idx_products_date_added` (`products_date_added`) ) TYPE=MyISAM AUTO_INCREMENT=30 ; and I myself look like http://www.dibcomputers.com/images/headbang.gif at the moment. ;) TIA! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
