sql建表，添加、删除、更改信息

创建学生表 comment ‘id,用于标识区分唯一的学生’ comment ‘学号，非空且唯一’ comment ‘姓名，非空’ comment ‘性别，默认为male’ default 'male’

  CREATE TABLE STUDENT(
         stu_id integer,
         stu_no char(12),
         stu_name varchar2(20),
         stu_gender varchar2(6) default 'male',
         stu_phone char(11),
         stu_address varchar2(30)
  ); 
 ALTER TABLE STUDENT ADD BORN_DATE DATE;
 ALTER TABLE STUDENT MODIFY stu_no NOT NULL CONSTRAINT UK_STUDENT_NO UNIQUE;

添加学生记录

  INSERT INTO STUDENT VALUES(1,1,'张三','female',111,'北京',null,'aaa');
  INSERT INTO STUDENT VALUES(2,2,'李四','male',111,'北京',null,'aaa');

删除学生记录

DELETE FROM STUDENT WHERE STU_NAME='张三';

更新学生记录

UPDATE STUDENT SET STU_ADDRESS='北京' WHERE STU_ADDRESS='上海';