如何获取将在PHPMyAdmin中重新创建sql表的查询 [英] How to get query that would recreate sql table in PHPMyAdmin

问题描述

我在MySQL服务器上有表，并希望获得可以重新创建表的SQL.

I have table on MySQL server and would like to get the SQL that would re-create the table.

如何获取查询以重新创建SQL表?

How do I get the query to recreate the SQL table?

推荐答案

mysqldump可以做到- http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

mysqldump can do it - http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

您可以像这样使用它:

mysqldump [databasename] [tablename] > mysqltablesql.sql

这篇关于如何获取将在PHPMyAdmin中重新创建sql表的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！