Topic: How To Select "Show DDL All table" : MySQL
Help Me Please !
How To Select "Show DDL All table" : MySQL ???
I Try write It Ok but show null in DDL_TABLE field
SELECT
information_schema.TABLES.TABLE_NAME,
information_schema.TABLES.TABLE_ROWS,
NUll AS DDL_TABLE
FROM
information_schema.TABLES,
WHERE
information_schema.TABLES.TABLE_SCHEMA = (DATABASE());
When itry add ddl script "Show Create Table" It Error
SELECT
information_schema.TABLES.TABLE_NAME,
information_schema.TABLES.TABLE_ROWS,
(SHOW CREATE TABLE information_schema.TABLES.TABLE_NAME) AS DDL_TABLE
FROM
information_schema.TABLES,
WHERE
information_schema.TABLES.TABLE_SCHEMA = (DATABASE());
Help Me Please !
Easy For Beginner Student For Me