· 8 years ago · Dec 27, 2017, 08:30 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 )ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
8
9INSERT INTO test1 (No,MD5SUM) VALUE (1,'XSEE56');