mysql建表语句

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;


– Table structure for account_info


DROP TABLE IF EXISTS account_info;
CREATE TABLE account_info (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
user_id int(11) NOT NULL COMMENT ‘用户信息id’,
create_time datetime(0) NULL DEFAULT NULL COMMENT ‘创建时间’,
update_time datetime(0) NULL DEFAULT NULL COMMENT ‘更新时间’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

上一篇:Spring--基于IOC的CRUD操作,springmvc面试题


下一篇:SpringSecurity + Mybatis用户登录认证过程