Skip to content
Advertisement

Tag: describe

SHOW COLUMNS from multiple tables

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

Advertisement