how do i fix this? the error says that the column count does not match value count.
thanks in advance!:)
--
-- Definition of table `assets`
--
DROP TABLE IF EXISTS `assets`;
CREATE TABLE `assets` (
`_id` int(10) NOT NULL auto_increment,
`_controlNum` varchar(255) NOT NULL,
`_category` varchar(255) NOT NULL,
`_subcategory` varchar(255) NOT NULL,
`_brand` varchar(255) NOT NULL,
`_product` varchar(255) default NULL,
`_memory` varchar(255) default NULL,
`_processor` varchar(255) default NULL,
`_motherboard` varchar(255) default NULL,
`_graphicsCard` varchar(255) default NULL,
`_hardDrive` varchar(255) default NULL,
`_productNum` varchar(255) default NULL,
`_serialNum` varchar(255) default NULL,
`_warrantyPeriod` varchar(255) default NULL,
`_warrantyEnd` date default NULL,
`_datePurchased` date NOT NULL,
`_supplier_id` int(10) default NULL,
`_cost` float default NULL,
`_status` varchar(255) default NULL,
`_assignedDate` date default NULL,
`_expectedLifeCycle` date default NULL,
`_retirementNoticeDate` date default NULL,
`_retireDate` date default NULL,
`_workstation_id` int(10) default NULL,
`_user_accounts_id` int(10) default NULL,
PRIMARY KEY (`_id`),
KEY `_supplier_id` (`_supplier_id`),
KEY `_workstation_id` (`_workstation_id`),
KEY `_user_accounts_id` (`_user_accounts_id`),
CONSTRAINT `assets_ibfk_1` FOREIGN KEY (`_supplier_id`) REFERENCES `supplier` (`_id`),
CONSTRAINT `assets_ibfk_2` FOREIGN KEY (`_workstation_id`) REFERENCES `workstation` (`_id`),
CONSTRAINT `assets_ibfk_3` FOREIGN KEY (`_user_accounts_id`) REFERENCES `user_accounts` (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `assets`
--
/*!40000 ALTER TABLE `assets` DISABLE KEYS */;
INSERT INTO `assets` (`_id`,`_controlNum`,`_category`,`_subcategory`,`_brand`,`_product`,`_memory`,`_processor`,`_motherboard`,`_graphicsCard`,`_hardDrive`,`_productNum`,`_serialNum`,`_warrantyPeriod`,`_datePurchased`,`_supplier_id`,`_cost`,`_status`,`_assignedDate`,`_expectedLifeCycle`,`_retirementNoticeDate`,`_retireDate`,`_workstation_id`,`_user_accounts_id`) VALUES
(1,'MTR00001','Hardware','Monitor','NEC','52V-bk 15\" LCD',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,1,3),
(2,'CPU00001','Hardware','CPU','Stilla','CB+ 100','mem1','proc1','moth1','gcar1','hddr1','105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,1,3),
(3,'KYB00001','Hardware','Keyboard','Logitech','K110',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,1,3),
(4,'MSE00001','Hardware','Mouse','Logitech','M110',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,1,3),
(5,'APP00001','Software','Microsoft Excel 2007','Microsoft','Excel 2007',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,1,3),
(6,'MTR00002','Hardware','Monitor','NEC','52V-bk 15\" LCD',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,2,2),
(7,'CPU00002','Hardware','CPU','Stilla','CB+ 200','mem2','proc2','moth2','gcar2','hddr1','105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,2,2),
(8,'KYB00002','Hardware','Keyboard','Logitech','K111',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,2,2),
(9,'MSE00002','Hardware','Mouse','Logitech','M111',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,2,2),
(10,'APP00002','Software','Microsoft Powerpoint 2007','Microsoft','Powerpoint 2007',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,2,2);
/*!40000 ALTER TABLE `assets` ENABLE KEYS */;