MySQL之联合查询和更新

MySQL之联合查询和更新

Mysql 运维：

6.进入数据库 keystone，通过 user 表和 local_user 表做联合查询，u 用来做user 表别名，lu 用来做 local_user 表别名，两表联合查询 nova 用户的 enabled 状态，查询语句中 user 表在 local_user 前面，将操作命令和返回结果以文本形式提交到答题框。

本题牵涉到两个表：user和local_user，我们不妨先看一下这两个表的结构和内容：

MariaDB [(none)]> use keystone;
MariaDB [keystone]> select * from user;
+----------------------------------+-------+---------+--------------------+
| id                               | extra | enabled | default_project_id |
+----------------------------------+-------+---------+--------------------+
| 09ede418b2174b8c888c2f48af68cfd5 | {}    |       1 | NULL               |
| 41c4011efd744c58b6b67f52f11818c9 | {}    |       1 | NULL               |
| 65ba7f2c77d64e8c8dff1ec941a08803 | {}    |       1 | NULL               |
| 6812f1eb68a74feabf2ed18049c66d7a | {}    |       1 | NULL               |
| 9663d056de034c1dbabafbb15f2a7db4 | {}    |       1 | NULL               |
| ab69b033f4b54b8396fe24e831454e65 | {}    |       1 | NULL               |
| d813d9a0c6094212bfe9babe9c4cf862 | {}    |       1 | NULL               |
+----------------------------------+-------+---------+--------------------+
7 rows in set (0.00 sec)

MariaDB [keystone]> select * from local_user;
+----+----------------------------------+----------------------------------+---------+
| id | user_id                          | domain_id                        | name    |
+----+----------------------------------+----------------------------------+---------+