$con= MySQL有关填空题_mysql 相关练习题

/*自己查询自己 把一张表看成是两张表。 表的设计。

SELECT

*

FROM

depart;

SELECT

d1. NAME '部门',

d2. NAME '分部门'

FROM

depart d1

INNER JOIN depart d2 ON d1.id = d2.did;

SELECT

d1. NAME,

d2. NAME

FROM

depart d1

INNER JOIN depart d2 ON d1.did = d2.id;

SELECT s.name,s.age,g.gname ,z.id from student s INNER JOIN grade g INNER JOIN zhongjian z ON z.tid=z.gid;*/

--学生表

create table students(

sno VARCHAR(3) not NULL,

sname VARCHAR(4) not NULL,

ssex VARCHAR(2) not NULL,

sbirthday datetime,class VARCHAR(5))--CREATE table courses(

cno VARCHAR(5) not null,

cname varchar(10) not null,

tno VARCHAR(10) not null)

CREATE table scores (

sno VARCHAR(3) not null,

cno VARCHAR(5) not null,

degree NUMERIC(10,1) not null)--老师表

create table teachers(

tno VARCHAR(3) not null,

tname VARCHAR(4) not null, tsex VARCHAR(2) not null,

tbirthday datetime notnull,prof varchar(6),

depart VARCHAR (10) not null)

insert into students (sno,sname,ssex,sbirthday,class)VALUES(108,'曾华','男','1977-09-01',95033);

insert into students (sno,sname,ssex,sbirthday,class)VALUES(105,'匡明','男','1975-10-02',95031);

insert in