sql问题解答创建表的语句

Question

表1“base_customers”结构如下图，其中CUSTOMERID为主键：　

1)写出创建表“base_customers”的语句。
2)查询表“base_customers”中姓“张”的记录。
3)删除表“base_customers”中 CARDNO大于等于75537的记录。
4)插入表“base_customers”中一条记录：CUSTOMERID=1,OUTID=20120218,NAME=刘德华，CARDNO=65536,CARDSN=1。
5)更新“rec_card_make”表中CUSTOMERID=8的记录，使CARDNO加1。

Answer 1

create table base_customers
(

    CustomerId bigint PRIMARY key,
    OutId bigint,
    NAME varchar(200),
    CardNo bigint (20),
    CardSn int
);
select * from base_customers where NAME like '张%';
delete from base_customers where CardNo >= 75537;
insert into base_customers(CustomerId,OutId,NAME,CardNo,CardSn) values(1,20120218,'刘德华',65536,1);
update base_customers set CardNo = CardNo+1 where CustomerId = 8;