USE information_schema;
SELECT TABLE_NAME, GROUP_CONCAT(COLUMN_NAME), GROUP_CONCAT(DATA_TYPE)
FROM `COLUMNS`
WHERE TABLE_SCHEMA = 'mydatabase'
GROUP BY TABLE_NAME
12,457 total views, 1 views today
USE information_schema;
SELECT TABLE_NAME, GROUP_CONCAT(COLUMN_NAME), GROUP_CONCAT(DATA_TYPE)
FROM `COLUMNS`
WHERE TABLE_SCHEMA = 'mydatabase'
GROUP BY TABLE_NAME
12,457 total views, 1 views today
Comentarios