Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (5k points)
edited by

Like INFORMATION_SCHEMA has all table names,comments etc. but where are the CREATE statements stored in MySql? Can I retrieve CREATE statements stored in one query for all tables?

1 Answer

0 votes
by (10.2k points)

mysqldump -h localhost -u root -p --no-data --compact  some_db

mysqldump -d --compact --compatible=mysql323 ${dbname}|egrep -v "(^SET|^/\*\!)"

If you want to get more insights into SQL, check out this SQL Course from Intellipaat.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Browse Categories

...