文件名称:ATM银行的sql小项目 写的不好见谅
文件大小:2KB
文件格式:TXT
更新时间:2021-05-30 05:07:51
SQL
create table user_info ( u_id bigint not null auto_increment, u_name varchar(20) not null, u_pid varchar(18) not null unique, u_tel varchar(12) not null, u_address varchar(50), primary key (u_id) )engine=InnoDB insert into user_info(u_id,u_name,u_pid,u_tel,u_address)values('01','一','130555063837830521', '13080251791', '福建厦门'); insert into user_info(u_id,u_name,u_pid,u_tel,u_address)values('02','二','130555063837830522', '13080251792', '福建厦门'); insert into user_info(u_id,u_name,u_pid,u_tel,u_address)values('03','三','130555063837830523', '13080251793', '福建厦门'); insert into user_info(u_id,u_name,u_pid,u_tel,u_address)values('04','四','130555063837830524', '13080251794', '福建厦门'); insert into user_info(u_id,u_name,u_pid,u_tel,u_address)values('05','五','130555063837830525', '13080251795', '福建厦门');