1:加is表示为空值;
eg查询没有上级领导的所有员工信息 mysql> select * from emp where MGR IS NULL;
+-------+-------+-----------+------+------------+--------+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | salary | COMM | DEPTNO |
+-------+-------+-----------+------+------------+--------+------+--------+
| 7839 | KING | PRESIDENT | NULL | 1981-11-17 | 5000 | NULL | 10 |
+-------+-------+-----------+------+------------+--------+------+--------+
1 row in set (0.00 sec)
2:Update是修改数据
Alter table 是修改表的结构。
3:lower(小写的)
将商品的名字,商品的类别全部转换成小写形式并展示所有信息。
mysql> select lower(product_name),lower(product_category) from products;
+---------------------+-------------------------+
| lower(product_name) | lower(product_category) |
+---------------------+-------------------------+
| smartphone | electronics |
| headphones | accessorics |
| t-shirt | clothing |
| mouse | electronics |
+---------------------+-------------------------+
4 rows in set (0.00 sec)
4:# 将商品类别和名称拼接起来并显示其余的信息。比如:Elctronics-Mouse
mysql> select product_id,pricep,concat(product_category,'-',product_name)【product_name本来就是列名,不需要加单引号】as product from products;
+------------+--------+------------------------+
| product_id | price | product |
+------------+--------+------------------------+
| 2 | 800.00 | Electronics-Smartphone |
| 3 | 100.00 | Accessorics-Headphones |
| 4 | 25.00 | Clothing-T-shirt |
| 5 | 20.00 | Electronics-Mouse |
+------------+--------+------------------------+
4 rows in set (0.00 sec)
5:like不能丢
写一条SQL查询语句,找出商品名称包含字母"e"的商品信息。
mysql> select *from products where product_name like '%e%';
6:CREATE TABLE 是用来创建表的
CREATE USER是创建用户的
7:给某个表添加某一列是ALTER TABLE … ADD…