mysql增加一条学生记录_Mysql基本操作记录

# DataBase：Mysql Tool：Navicat# 创建学生信息表create tableStudent (

# 学号作为主键，varchar是可变长字符串

SnoVARCHAR(20) primary key,

# 使用default定义默认值， Sage int auto_increment 可设置自动递增

Sageint default 18,

SnameVARCHAR(20)

)

# 创建老师表create tableTeacher (

TnoVARCHAR(20) primary key,

TnameVARCHAR(20),

TageINT,

AcademyNoVARCHAR(20),

# 创建外键约束constraint Fk_Teacher_Academy foreign key(AcademyNo) referencesAcademy(AcademyNo)

)

# 创建课程表create tableCourse (

# 列级定义主键

CnoVARCHAR(20) primary key,

TnoVARCHAR(20),

CnameVARCHAR(50)

)

# 添加约束alter table Course add constraint Fk_Course_Teacher foreign key(Tno) referencesTeacher(Tno);

# 创建成绩表create tableSc (

SnoVARCHAR(20),

CnoVARCHAR(20),

ScoreFLOAT,

# 表级定义多个主键primary key(Sno, Cno),

# 添加外键并级联操作constraint Fk_Sc_Student foreign key(Sno) references Student(Sno) on delete cascade on update cascade,

# 默认删除跟修改都是restrictconstraint Fk_Sc_Course foreign key(Cno) referencesCourse(Cno)

)

# 查看创建的表select * fromStudent

# 修改表操作，#增加一列alter tableTeacheradd column Tage VARCHAR(3);

# 删除指定列alter