我有一个名为"name“的列,它存在于mysql数据库的所有表中。我想列出所有表中的所有名称,所以我使用以下查询
select name from (SELECT table_name FROM information_schema.tables WHERE table_type然后,我使用show tables并将输出存储在另一个名为table_list的表</
AS `Colleges__*` FROM college_admins CollegeAdmins LEFT JOIN colleges Colleges O' at line 1SELECT Colleges.* AS `Colleges__*` FROM college_admins CollegeAdmins LEFT JOIN colleges Collegesnear 'AS `Colleges__*` FROM `college_admins` `CollegeAdmins` LEFT JO