Navicat Premium 15 :后台 SQL预览
CREATE TABLE NewTable (id int(11) NOT NULL AUTO_INCREMENT ,operation varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,operation_id int(11) NULL DEFAULT NULL ,operation_time datetime NULL DEFAULT NULL ,operation_params varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,PRIMARY KEY (id))ENGINE=InnoDBDEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ciAUTO_INCREMENT=2ROW_FORMAT=DYNAMIC;
CREATE TABLE ‘student_log’(’id‘ INT NOT NULL AUTO_INCREMENT, 这里有一个bug :INT没有11内存’operation‘ VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,’operation_id‘ INT(11),’operation_time‘ DATE, 2019-07-14 or '2019-07-14'’operation_params‘ VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL)ENGINE=INNODB 往下没有空格DEFAULT CHARACTER SET