2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→SHOW: Added some more
(→Numbers: Added link to mysql site) |
(→SHOW: Added some more) |
||
| Line 182: | Line 182: | ||
</source> | </source> | ||
== SHOW == | == SHOW etc== | ||
Shows general information about a database, it's tables, columns etc. | Shows general information about a database, it's tables, columns etc. | ||
<source lang="mysql"> | <source lang="mysql"> | ||
SHOW STATUS; # Shows general info | SHOW STATUS; # Shows general info | ||
SHOW DATABASES; # Show databases | |||
SHOW TABLES; # Show tables in the current database | |||
DESCRIBE table; # Show column information for a table | |||
SHOW INDEX FROM table; # Show tables index/key information | |||
SHOW CREATE TABLE table; # Shows syntax that would be used to recreate a table | SHOW CREATE TABLE table; # Shows syntax that would be used to recreate a table | ||
</source> | </source> | ||