Java·测试表

测试表

DROP TABLE  student ;
CREATE TABLE `Student` (
 `id` int(11) NOT NULL AUTO_INCREMENT
 ,`name` varchar(255)  
 ,`dopn` varchar(255) 
 ,`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'
 ,`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
 , PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8
;
SELECT * FROM student  ;
insert into student values (1,'山','s',null,null );
insert into student values (2,'木','m','',null );
insert into student values (3,'水','h',NULL,null );