mysql - 选择 * 作为 {table_name}.{field_name}

Question

是否可以编写以下查询，以便结果“键”包含字段所属表的名称，而不仅仅是字段名称。

SELECT * FROM books

结果应该是这样的:

| books.id | books.name | etc.
| 1        | She        |
| 2        | Lolita     |

Answer 1

你必须单独为它们起别名..

SELECT id as 'books.id', name as 'books.name' FROM books