MySQl 简单应用

查询

select distinct * from t_stud_info;

select t_stud_info.sName as '姓名',
t_courses.courseName as '课程名称',
t_stud_course_info.scScores as '成绩',
t_courses.courseCredit as '学分'
from(t_stud_course_info inner join t_courses  
on t_stud_course_info.scCourseID = t_courses.courseID )
inner join t_stud_info 
on t_stud_info.sNumber = t_stud_course_info.scNumber  
where sName = '张三'  
order by t_stud_course_info.scNumber;

更新

 update t_stud_course_info 
 inner join t_courses  on t_stud_course_info.scCourseID = t_courses.courseID 
 inner join t_stud_info on t_stud_info.sNumber = t_stud_course_info.scNumber 
set scScores = '55' where sName = ''and courseName = '复变函数' ; 

插入

insert into test.t_stud_course_info ( scNumber, scCourseID, scScores, scYear) 
values ('1403150108','1403','88','2017-2018');

同时插入多条数据

insert into test.t_stud_course_info ( scNumber, scCourseID, scScores, scYear ,scTerm )
values 
('1403150110','14010271','100','2017-2018','1'),     ('1403150110','14040421','100','2017-2018','1'),('1403150110','14040402','100','2017-2018','1'),('1403150110','14040781','100','2017-2018','1');

删除

delete from t_stud_course_info  where scCourseID = '14040781';