create table tbl_customer
(
customerID char(18) not null primary key check(len(customerID)=18 ),
customerName varchar(20) not null,
customerMobile char(11) unique check(len( customerMobile)=11 ), check( customerMobile like '1[3,5,8]%') ,
customerGender char(2) default('男') not null,
customerBirthday datetime,
customercountry varchar(15),
customercity varchar(15),
customerzipcode char(6),
customerVip char(1) default('否')
)
insert into tbl_customer (customerID,customerName)values ('330125468654213624','张杰')
insert into tbl_customer values ('330522198101016528','张三','13567882628','男','1986-06-18','china','杭州',null,'是')
insert into tbl_customer values ('330437199211256321','李四','13831525856','女','1995-06-01','china','江苏','301425','否')
insert into tbl_customer values ('336514199903086528','山鸡','15035214517','男','1975-03-18',' USA','Seattle',null,'是')