mysql表示所有列_MySQL-从多个表中显示列

最新推荐文章于 2022-04-21 15:34:42 发布

Bu君

最新推荐文章于 2022-04-21 15:34:42 发布

阅读量126

点赞数

文章标签： mysql表示所有列

本文链接：https://blog.csdn.net/weixin_35688459/article/details/113223118

版权

I am trying to get the column names from 2 tables.

I tried a query like: (SHOW COLUMNS FROM users) UNION (SHOW COLUMNS FROM posts) but that does not work & returns a syntax error. I tried the same query using DESCRIBE but that did not work either. How can I get all the column names from multiple tables in a single query? Is it possible?

解决方案"SHOW COLUMNS displays information about the columns in a given table"

So you can't really use it on multiple tables. However if you have information_schema database then you could use it like follows:

select column_name

from `information_schema`.`columns`

where `table_schema` = 'mydb' and `table_name` in ('users', 'posts');

Here you'd have to replace the mydb with your database name, or just use DATABASE().