How to see table definition statements in MySQL?
Use the command described in the tutorial to find complete CREATE TABLE SQLs for MySQL tables.
Execute the command below from any MySQL client.
SHOW CREATE TABLE <table name>;
Replace <table name> with your table name
A much faster and simpler approach of doing the same thing requires MySQL Query Browser. From Query browser, right click on the table name and click on 'Copy CREATE statement to Clipboard' OR Ctrl-C. The CREATE table statement will be copied to your clipboard from where you can paste it wherever you want.
Did this tutorial help a little? How about buy me a cup of coffee?
Please feel free to use the comments form below if you have any questions or need more explanation on anything. I recommend thoroughy testing on a production-like test system first before moving to production.
tags cloud
popular searches
free download for mysql database server 5.1.5, php, gearman, bison, linux, java, ubuntu, mysql, source code, mysql mysql, tools, install mysql, mysql initialization, install cairo, laptop
Similar Tutorials:
- MySQL Query Cache not necessarily a bad thing
- Install MySQL Server 5.0 and 5.1 from source code
- Transfering MySQL Administrator/Query Browser connection details
- MySQL open files limit: open-files-limit VS open_files_limit on Linux
- How to install MySQL Gearman UDF on Ubuntu/Debian Linux
Tutorials in 'Database Management Systems > MySQL' (more):
- How to delete rows in table when PK is referenced in another table
- Unique primary keys(PKs) for MySQL using Redis
- How to rename MySQL DB by moving tables
- How to set innodb_flush_log_at_timeout in MySQL 5.6?
- Is MySQL 5.6 slower than MySQL 5.5? No, it's faster
Comments (write a comment):
0 comments so far. Be the first one to leave a comment on this article.