create table t_base_user(   oid bigint(20) not null primary key auto_increment,   name varchar(30) null comment "name",   email varchar(30) null comment "email",   age int null comment "age",   telephone varchar(30) null comment "telephone",   status tinyint(4) null comment "0 无效 1 有效",   created_at datetime null default now() comment "创建时间",   updated_at datetime null default now() comment "修改时间"  ) ### 新建索引alter table t_base_user add index idx_email(email); alter table t_base_user add index idx_name(name); alter table t_base_user add index idx_telephone(telephone); ### 新增记录: INSERT INTO `andyqian`.`t_base_user` (`name`, `email`, `age`, `telephone`, `status`, `created_at`, `updated_at`) VALUES ('111111', 'andytohome@gmail.com', '111', '12345678901', '1', now(),now());