当前位置：网站首页>sql problem solving statement to create a table

sql problem solving statement to create a table

2022-08-09 06:02:00 【CSDN Q&A】

The structure of "base_customers" in Table 1 is as shown below, in which CUSTOMERID is the primary key:

1) Write a statement to create the table "base_customers".
2) Query the records with the surname "Zhang" in the table "base_customers".
3) Delete the records whose CARDNO is greater than or equal to 75537 in the table "base_customers".
4) Insert a record in the table "base_customers": CUSTOMERID=1, OUTID=20120218, NAME= Andy Lau, CARDNO=65536, CARDSN=1.
5) Update the record of CUSTOMERID=8 in the "rec_card_make" table to increase CARDNO by 1.

原网站

版权声明
本文为[CSDN Q&A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/221/202208021455352853.html