Get data from a table in MySQL

In MYSQL there are several methods to know if a table exists or get information from the table directly from the SHEMA, one way is as follows:

SELECT
 TABLE_SCHEMA AS BD,
 TABLE_NAME AS NOMBRE_TABLA, 
 CREATE_TIME AS FECHA_CREACION,
 ENGINE 
FROM information_schema.tables 
WHERE table_name like '%tableTest%' 
ORDER BY table_name DESC;

También te podría gustar...