Ways to view MySQL table structure and table creation statements

2. There are three ways to view the MySQL table structure:
4. 1,DESC tablename;
6. For example:
8. To view the Jos_modules table Structure command:
10. Desc Jos_modules;
12. View results:
14. mysql> desc jos_modules;
16. +------------------+---------------------+------+-----+---------------------+----------------+  
18. | Field | Type | Null | Key | Default |  Extra |
20. +------------------+---------------------+------+-----+---------------------+----------------+  
22. | id                | int (one)               | no   | pri | NULL                 | auto_ increment |  
24. | title            | text                 |  no   |     | NULL                 |                 |  
26. | content          | text                 |  no   |     | NULL                 |                 |  
28. | ordering         | int (11)              | NO    |     | 0                    |                 |  
30. | Position | varchar (50) |     YES | |                NULL |  |
32. | Checked_out | Int (one) unsigned |     NO | |                0 |  |
34. | Checked_out_time | datetime |     NO | |                0000-00-00 00:00:00 |  |
36. | Published | tinyint (1) | NO | MUL |                0 |  |
38. | module           | varchar (         | yes | mul)  | null                 |                 |  
40. | Numnews | Int (11) |     NO | |                0 |  |
42. | Access | tinyint (3) unsigned |     NO | |                0 |  |
44. | Showtitle | tinyint (3) unsigned |     NO | |                1 |  |
46. | params | Text |     NO | |                NULL |  |
48. | Iscore | Tinyint (4) |     NO | |                0 |  |
50. | client_id | Tinyint (4) |     NO | |                0 |  |
52. | Control | Text |     NO | |                NULL |  |
54. +------------------+---------------------+------+-----+---------------------+----------------+  
56. 2, show create table tablename;
58. For example:
60. To view the Jos_modules table Structure command:
62. Show create table jos_modules;
64. View results:
66. Mysql> Show create table jos_modules;
68. Jos_modules | CREATE TABLE ' jos_modules ' (
70. ' ID ' int (one) not NULL auto_increment,
72. ' title ' text is not NULL,
74. ' Content ' text is not NULL,
76. ' Ordering ' int (one) not NULL DEFAULT ' 0 ',
78. ' Position ' varchar DEFAULT NULL,
80. ' Checked_out ' int (one) unsigned not NULL DEFAULT ' 0 ',
82. ' Checked_out_time ' datetime not NULL DEFAULT ' 0000-00-00 00:00:00 ',
84. ' Published ' tinyint (1) not NULL DEFAULT ' 0 ',
86. ' module ' varchar DEFAULT NULL,
88. ' Numnews ' int (one) not NULL DEFAULT ' 0 ',
90. ' Access ' tinyint (3) unsigned not NULL DEFAULT ' 0 ',
92. ' Showtitle ' tinyint (3) unsigned not NULL DEFAULT ' 1 ',
94. ' Params ' text is not NULL,
96. ' Iscore ' tinyint (4) not NULL DEFAULT ' 0 ',
98. ' client_id ' tinyint (4) not NULL DEFAULT ' 0 ',
100. ' Control ' text is not NULL,
102. PRIMARY KEY (' id '),
104. KEY ' published ' (' published ', ' Access '),
106. KEY ' newsfeeds ' (' Module ', ' published ')
108. ) Engine=myisam auto_increment=145 DEFAULT Charset=utf8
110. 3, use INFORMATION_SCHEMA; SELECT * from columns where table_name=' tablename '
112. For example:
114. To view the Jos_modules table Structure command:
116. Use INFORMATION_SCHEMA;
118. SELECT * from columns where table_name=' jos_modules ';

Ways to view MySQL table structure and table creation statements