
复制CREATE TABLE account ( id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键Id,实战深分 name varchar(255) DEFAULT NULL COMMENT 账户名, balance int(11) DEFAULT NULL COMMENT 余额, create_time datetime NOT NULL COMMENT 创建时间, update_time datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 更新时间, PRIMARY KEY (id), KEY idx_name (name), KEY idx_update_time (update_time) //索引 ) ENGINE=InnoDBAUTO_INCREMENT=1570068 DEFAULT CHARSET=utf8ROW_FORMAT=REDUNDANTCOMMENT=账户表; 1.2.3.4.5.6.7.8.9.10.





