### 创建表
CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) NOT NULL,
Ssex CHAR(4),
Sage SMALLINT,
Sdept CHAR(20)) tablespace gaospace;
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) NOT NULL,
Ssex CHAR(4),
Sage SMALLINT,
Sdept CHAR(20)) tablespace gaospace;
### 插入数据
INSERT INTO Student VALUES('0201','赵伟','男',18,'cs');
INSERT INTO Student VALUES('0202','张力虹','男',19,'is');
INSERT INTO Student VALUES('0203','徐秀美','女',21,'is');
INSERT INTO Student VALUES('0204','刘平','男',20,'cs');
INSERT INTO Student VALUES('0205','姚家全','男',19,'cs');
INSERT INTO Student VALUES('0206','上关美云','女',23,'ma');
###
### 修改表的字段类型
alter table student modify ssex char(6);
INSERT INTO Student VALUES('0202','张力虹','男',19,'is');
INSERT INTO Student VALUES('0203','徐秀美','女',21,'is');
INSERT INTO Student VALUES('0204','刘平','男',20,'cs');
INSERT INTO Student VALUES('0205','姚家全','男',19,'cs');
INSERT INTO Student VALUES('0206','上关美云','女',23,'ma');
###
### 修改表的字段类型
alter table student modify ssex char(6);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26435490/viewspace-1076555/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
