开发者

How to show MYSQL statements that show how to create a particular table?

开发者 https://www.devze.com 2023-01-11 12:07 出处:网络
I\'ve created and edited a couple of tables and don\'t want to recreate them from scratch if the database gets erased. What command allows me to \"export\" the field names and settings (NOT the conten

I've created and edited a couple of tables and don't want to recreate them from scratch if the database gets erased. What command allows me to "export" the field names and settings (NOT the content) as a ready to use MYSQL command that I can paste back on the MYSQL 开发者_如何学Goprompt?


SHOW CREATE TABLE tablename;

Reference: mySQL docs

0

精彩评论

暂无评论...
验证码 换一张
取 消