How can I get all CREATE statements of MySQL Tables in just a 1 query result?

Question

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?

Answer 1

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.