BwbMnGKU

1DROP TABLE IF EXISTS preventive_maintenance;
2
3-- create table
4CREATE TABLE `preventive_maintenance` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `device_type` varchar(11) NOT NULL,
7  `device_serial` varchar(20) NOT NULL,
8  `customer_name` varchar(20) NOT NULL,
9  `error_code` varchar(20) NOT NULL,
10  `resolutiom` varchar(20) NOT NULL,
11  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
14
15INSERT INTO `preventive_maintenance`
16    (`device_type`,`device_serial`,`customer_name`,`error_code`,`resolutiom`,`timestamp`)
17VALUES
18    ('a1','02598352','Dr. Wonda','35','Power','Over Heat',now()); 
19     
20Error Code: 1136. Column count doesn't match value count