练习题1
CREATE TABLE text
.addressbook
(
regist_no
INT NOT NULL,
name
VARCHAR(128) NOT NULL,
address
VARCHAR(256) NOT NULL,
tel_no
CHAR(10) NULL,
mail_address
CHAR(20) NULL,
PRIMARY KEY (regist_no
));
结果:
练习题2
在workbrench中操作
或者添加语句
练习题3
练习题4
因为删除后表无法恢复,只能重新插入
CREATE TABLE text
.addressbook
(
regist_no
INT NOT NULL,
name
VARCHAR(128) NOT NULL,
address
VARCHAR(256) NOT NULL,
tel_no
CHAR(10) NULL,
mail_address
CHAR(20) NULL,
postal_code
Char(8) NULL,
PRIMARY KEY (regist_no
));
MYSQL学习TASK 00-01
![](https://img-home.csdnimg.cn/images/20240711042549.png)