用户表: create table userInfo( id int not null unique auto_increment, name varchar(10)not null, password varchar(20) not null, nickname varchar(10) not null); 代码记录表: create table code_record( id int not null unique auto_increment, user_id int, foreign key(user_id) references userInfo(id) ,外键关联 lineNumber varchar(20) not null, createTime datetime not null);
插入数据:
insert into userinfo(
name,password) values('whq','123456');
删除一条数据
delete from userinfo where id=2;
更改编码格式为utf8(支持中文)
alter table table_name convert to character set utf8;