You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
table1: id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, password varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci , gender tinyint(4) DEFAULT NULL COMMENT '0:男 1:女 2:保密'
table2: id int NOT NULL AUTO_INCREMENT PRIMARY KEY, password varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci , gender tinyint DEFAULT NULL COMMENT '0:男 1:女 2:保密'
本来是一样的,结果对比会不一样,工具把int与int(11),tinyint与 tinyint(4) 定义为不一样了,而且还会多一条
MODIFY COLUMN id int(11) NOT NULL auto_increment FIRST,
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
table1:
id
int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,password
varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ,gender
tinyint(4) DEFAULT NULL COMMENT '0:男 1:女 2:保密'table2:
id
int NOT NULL AUTO_INCREMENT PRIMARY KEY,password
varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ,gender
tinyint DEFAULT NULL COMMENT '0:男 1:女 2:保密'本来是一样的,结果对比会不一样,工具把int与int(11),tinyint与 tinyint(4) 定义为不一样了,而且还会多一条
MODIFY COLUMN
id
int(11) NOT NULL auto_increment FIRST,Beta Was this translation helpful? Give feedback.
All reactions