How to generate the DDL for all tables in a database of MySQL at once. I know that the following query will output the DDL for a table. But I want DDL of all tables at once because I am having hundreds of tables in my database.
show create table .
For example:
show create table projectdb.customer_details;
The above query will result in DDL of customer_details table.
I am using MySQL with MySQL workbench on Windows OS.
解决方案
You can do it using the mysqldump command line utility:
mysqldump -d -u -p -h
The -d option means "without data".