1 Topic by prahousefamily (edited by prahousefamily 2018-09-26 09:09:19)

  • Registered: 2014-02-17
  • Posts: 365

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 !


https://image.ibb.co/kCF8nU/2018_09_26_001.png

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: How To Select "Show DDL All table" : MySQL

Unfortunately my knowledge in MySQL is not enough to help with this question.
This question for stack overflow.

Dmitry.