MariaDB y MySQL – Cómo listar columnas, tablas y tipos de una base de datos
USE information_schema; SELECT TABLE_NAME, GROUP_CONCAT(COLUMN_NAME), GROUP_CONCAT(DATA_TYPE) FROM `COLUMNS` WHERE TABLE_SCHEMA = 'mydatabase' GROUP BY TABLE_NAME
USE information_schema; SELECT TABLE_NAME, GROUP_CONCAT(COLUMN_NAME), GROUP_CONCAT(DATA_TYPE) FROM `COLUMNS` WHERE TABLE_SCHEMA = 'mydatabase' GROUP BY TABLE_NAME