How to view the SQL statement to create a table in phpMyAdmin

Below, the phpmyadmin tutorial column will introduce to you how to view and create table SQL statements in phpMyAdmin. I hope it will be helpful to friends in need!

Method 1:

In the phpMyAdmin management tool, select a table in a database on the left and click on the upper right When you see an "Export" button, you can export the sql file and open it with text or development tools. There will be SQL statements to create the table;

But this method is not very good, because the sql file also contains There is other information, and if you are a beginner, it may not be easy to see where to start and where to end!

Method 2:

The author recommends that you use this method, which is at least faster and more convenient than the first method above. Use the show create table statement to query;

For example, when viewing the online table, that is, show create table online, the text queried may be incomplete. Click "Options" and select "Complete Content"!

The above is the detailed content of How to view the SQL statement to create a table in phpMyAdmin. For more information, please follow other related articles on the PHP Chinese website!