· 8 years ago · Dec 27, 2017, 07:50 PM
1DROP TABLE IF EXISTS `test1`;
2CREATE TABLE `test1`(
3 `No` int(11) NOT NULL AUTO_INCREMENT,
4 `TIME` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
5 `MD5SUM` varchar(100) NOT NULL,
6 PRIMARY KEY (`No`)
7 )
8
9INSERT INTO test1 (No,MD5SUM) VALUES (1,'XSEE56');