MYSQL必刷50题
一碗机智的糖浆
这个作者很懒,什么都没留下…
展开
-
01.MYSQL必刷50题--1-5题
– 1、查询"01"课程比"02"课程成绩高的学生的信息及课程分数SELECT student.*,a_score.s_score 01_score,b_score.s_score 02_score FROM student JOIN score a_score ON student.s_id = a_score.s_id AND a_score.c_id='01' JOIN score b_score ON student.s_id = b_score.s_id AND b_score.c_id=..原创 2020-07-26 17:39:12 · 208 阅读 · 0 评论 -
MYSQL必刷50题--00.建库,建表,插入数据
–建表–学生表create table if not exists student( s_id varchar (20), s_name varchar (20) not null default '', s_birth varchar (20)not null default '', s_sex varchar (10) not null default '', primary key (s_id) ) ;–课程表create table course( c_id ...原创 2020-07-26 17:13:35 · 214 阅读 · 0 评论