表:
create table user_m( id int(11) not null auto_increment,
user varchar(16) not null,
password varchar(16) not null,
last_time datetime not null, primary key(id), unique key(id)); 含自增字段id,datetime字段last_time,
给其添加记录的方法,注意红色部分:
insert into user_m values(id,'admin','1234',now());