MySQL DML操作--------多表联合查询实战
mysql> desc employees;+-----------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| name | varchar(64) | NO | | NULL | |
| sex | enum('M','F') | NO | | NULL | |
| age | int(11) | NO | | NULL | |
| depart_id | bigint(20) | NO | | NULL | |
+-----------+---------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> desc departments;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | bigint(20)| NO | PRI | NULL | auto_increment |
| name| varchar(64) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
页:
[1]