5、MySQL的基本使用

systemctl restart mysqld.service

net start mysql8

mysql -u root -pLiuguozhen@19

创建库：mysql> create database 20234660ku character set utf8 collate utf8_general_ci;

进入库：mysql> use 20234660ku;

学生表: mysql> create table Student(Sid char(8) primary key,Sname varchar(10) not null,Sage datetime not null,Ssex enum('男','女') not null);

教师表：mysql> create table Teacher(Tid char(4) primary key,Tname varchar(10) not null);

课程表：mysql> create table Course(Cid char(6) primary key,Cname varchar(30) not null,Tid char(4) not null,foreign key(Tid) references Teacher(Tid));

成绩表：mysql> create table SC(Sid char(8) not null,Cid char(6) not null,score float not null,primary key(Sid,Cid),foreign key(Sid) references Student(Sid),foreign key(Cid) references Course(Cid));

作业

create database School character set utf8 collate utf8_general_ci;

mysql> create table student(学号 char(10) primary key,姓名 char(10) not null,性别 char(2) not null,出生日期 date,地区 varchar(20) ,民族 char(10) ,班级编号 char(6) );

mysql> insert into student values('20234660','刘国振','男','2000-09-13','吉安','汉族','4923B2');

mysql> insert into student values('20234663','张三','女','2001-03-24','赣州','畲族','4923B1');

mysql> insert into student values('20234664','李四','男','2000-02-05','南昌','汉族','4923B2');

查看库show databases;

查看表Show tables;

查看表的结构：Desc Student;

查看定义表的语句： show create table Student;