直接创建表:
create table teststaff(id int not null auto_increment,idCard varchar(10),primary key(id)) engine=myisam;
把innodb改成myisam
ALTER TABLE 'staff' ENGINE = MyISAM;
获取最后更新时间:
select 'staff',UPDATE_TIME from information_schema.TABLES where TABLE_SCHEMA='test' order by UPDATE_TIME desc limit 1;