CREATE TABLE members(
member_id int auto_increment primary key,
member_login varchar(20) NOT NULL,
member_password varchar(20) NOT NULL,
member_level int NOT NULL DEFAULT 1,
first_name varchar(50) NOT NULL,
last_name varchar(50) NOT NULL,
email varchar(50)NOT NULL,
phone varchar(50) NULL,
address varchar(50) NULL,
notes text NULL,
card_type_id int NULL,
card_nmber varchar(50) NULL
);这是建的表
member_id int auto_increment primary key,
member_login varchar(20) NOT NULL,
member_password varchar(20) NOT NULL,
member_level int NOT NULL DEFAULT 1,
first_name varchar(50) NOT NULL,
last_name varchar(50) NOT NULL,
email varchar(50)NOT NULL,
phone varchar(50) NULL,
address varchar(50) NULL,
notes text NULL,
card_type_id int NULL,
card_nmber varchar(50) NULL
);这是建的表
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货