MySQL show create table 'tablename'

Mysql> show create table tb_common_member;
+ ------------------ + ------------------------------------------------
---- +
| Table | CREATE TABLE
|
+ ------------------ + ------------------------------------------------
---- +
| Tb_common_member | create table 'tb _ common_member '(
'Uid' mediumint (8) unsigned not null auto_increment,
Primary Key ('uid ')
) Engine = InnoDB default charset = Latin1 |
+ ------------------ + ------------------------------------------------
---- +
1 row in SET (0.00 Sec)

Mysql>

 

3. Use information_schema; select * from columns where table_name = 'tablename'
For example:
Command to view the structure of the jos_modules table:
Use information_schema;
Select * from columns where table_name = 'jos _ Les ';
View results:

 

Mysql> select table_name from columns where table_name = 'tb _ common_member ';
+ ------------------ +
| Table_name |
+ ------------------ +
| Tb_common_member |
+ ------------------ +
1 row in SET (0.04 Sec)

 

Mysql>