mysql命令
- 查看数据库表命令 : show tables;
- 查看数据库表结构命令 : show columns from [table_name];
sql语言
As
select StudentName as Name from Student;
属性重命名;NOT > AND > OR 逻辑运算优先级:
select * from Student
where Dept = “计算机系” OR Dept = “电子系” AND Age > 18;
选择所有计算机系学生和年龄18以上的电子系学生。is NULL / is not NULL 空值判断,不可用<> | =;
字符串匹配