我试图从SELECT声明中创建一个新的MySQL:
CREATE TABLE site_database AS(SELECT database_id, name, description, site_id FROM sitematrix_databases INNER JOIN site
matrix_site_databases ON sitematrix_site_databases.database_id = sitematrix_data
bases.database_id);当我执行SELECT语句时,我得到:
+-------------+--------+-------------+-------------+---------+
| database_id | name | description | database_id | site_id |
+-------------+--------+-------------+-------------+---------+
| 5 | tc2007 | | 5 | 1 |
| 5 | tc2007 | | 5 | 8 |
| 5 | tc2007 | | 5 | 9 |
| 5 | tc2007 | | 5 | 12 |
| 5 | tc2007 | | 5 | 14 |
+-------------+--------+-------------+-------------+---------+但是,当我尝试创建表时,我得到:
ERROR 1052 (23000): Column 'database_id' in field list is ambiguous我怎么解决这个问题?