知识回顾
创建表customer
添加记录
CREATE TABLE `customer` (
`id` int(11) NOT NULL,
`name` char(10) NOT NULL DEFAULT '',
cost_m int ,
`date` datetime NOT NULL,
`signin` tinyint(4) NOT NULL DEFAULT '0' COMMENT '登录次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `customer`
VALUES ('1', '小明', 500,'2016-04-22 15:25:33',
'1'),
('2', '小王',800, '2016-04-20 15:25:47', '3'),
('3', '小丽', 700,'2016-04-19 15:26:02', '2'),
('4', '小王',300 ,'2016-04-07 15:26:14', '4'),
('5', '小明',150, '2016-04-11 15:26:40', '4'),
('6', '小明',210 ,'2016-04-04 15:26:54', '2');
