CREATE TABLE `core_audit` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`FUNCTION_CODE` varchar(45) DEFAULT NULL,
`FUNCTION_NAME` varchar(45) DEFAULT NULL,
`USER_ID` int(11) DEFAULT NULL,
`USER_NAME` varchar(45) DEFAULT NULL,
`IP` varchar(45) DEFAULT NULL,
`CREATE_TIME` datetime(6) DEFAULT NULL,
`SUCCESS` tinyint(4) DEFAULT NULL,
`MESSAGE` varchar(250),
`ORG_ID` varchar(45) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
-
取中间出现错误的一段sql来进行剖析
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) DEFAULT NULL,
`SUCCESS` tinyint(4) DEFAULT NULL,
`MESSAGE` varchar(250' at line 8