创建数据库表:id为主键,自增长
create table phoneusers(
id int not null AUTO_INCREMENT,
phone varchar(32) not null,
password varchar(32) not null,
username varchar(32) not null,
city varchar(32) not null,
imei varchar(32) not null,
primary key(id)
);
向表中插入数据:
insert into phoneusers(phone, password, username, city, imei) values("13533445566", "xiaoxiao", "xiaoxiao", "shenzhen", "111111111111111");