1.插入语句
insert into stu(name,age)values('张三','18');
2.update语句
update stu set name='张七' where name='赵六';
3.删除语句
delete from stu where name='李四';
4.查询语句
select * from stu where name='李四';
模糊查询 like
%表示任意多个字符 下划线表示任意一个字符
select * from stu where name like '李%';
select * from stu where name like '_四';
is null 判断是否为空
select name from stu where age is null;
不能用age = null因为在SQL语句中 判断null=null会返回null
order by 排序
select name from stu where order by age;
默认排序按升序 如果需要按降序排列 需要加desc
select name from stu where order by age desc;
多表查询例子
mysql> select s.* tname from stu s,tea t where s.tid=t.tid;
+----+------+-----+-----+
| id | name | age | tid |
+----+------+-----+-----+
| 1 | 张七 | 18 | 1 |
| 3 | 王五 | 22 | 3 |
| 4 | 赵八 | 13 | 3 |
+----+------+-----+-----+
3 rows in set
mysql> select s.* tname from stu s,tea t;
无条件的多表查询 输出广义笛卡尔积
+----+------+-----+-----+
| id | name | age | tid |
+----+------+-----+-----+
| 1 | 张七 | 18 | 1 |
| 3 | 王五 | 22 | 3 |
| 4 | 赵八 | 13 | 3 |
| 1 | 张七 | 18 | 1 |
| 3 | 王五 | 22 | 3 |
| 4 | 赵八 | 13 | 3 |
| 1 | 张七 | 18 | 1 |
| 3 | 王五 | 22 | 3 |
| 4 | 赵八 | 13 | 3 |
| 1 | 张七 | 18 | 1 |
| 3 | 王五 | 22 | 3 |
| 4 | 赵八 | 13 | 3 |
+----+------+-----+-----+
12 rows in set
mysql> select s.* tname from stu s natural join tea t;
+----+------+-----+-----+
| id | name | age | tid |
+----+------+-----+-----+
| 1 | 张七 | 18 | 1 |
| 3 | 王五 | 22 | 3 |
| 4 | 赵八 | 13 | 3 |
+----+------+-----+-----+
3 rows in set
mysql> select s.* tname from stu s join tea t on s.tid=t.tid;
+----+------+-----+-----+
| id | name | age | tid |
+----+------+-----+-----+
| 1 | 张七 | 18 | 1 |
| 3 | 王五 | 22 | 3 |
| 4 | 赵八 | 13 | 3 |
+----+------+-----+-----+
3 rows in set