2020.03.12 sqlyogDML语言

-- select * from student.school;
-- select * from student.school where city_name='哈尔滨市' or level ='本科' order by province_id,id desc;
-- select upper(english_name) as '大学英文名称' from student.edu_school ;
-- select substr(school_name,1,4) from student.school where city_name like '哈%';
-- select school_name,length(school_name) from student.school where city_name='哈尔滨市' order by LENGTH(school_name) desc;
-- select * from student.school where school_id like '411101%';
-- select * from student.school order by rand() limit 5 ;
-- select s.*, case province_name when '贵州省' then '这是贵州的大学' else '其他地方的大学' end as newname from student.school s;