mysqlshow를 이용하여 리눅스 쉘상태에서 특정 테이블의 컬럼(column)정보들 확인하기

[root@file bin]# pwd

/usr/local/mysql/bin

[root@file bin]# ./mysqlshow -u root -p temp_db2 temptable

Enter password: ********

Database: temp_db2  Table: temptable  Rows: 0

+-------+--------------+------+-----+---------+-------+---------------------------------+

| Field | Type         | Null | Key | Default | Extra | Privileges                      |

+-------+--------------+------+-----+---------+-------+---------------------------------+

| uid   | mediumint(3) |      | PRI | 0       |       | select,insert,update,references |

| name  | varchar(12)  |      |     |         |       | select,insert,update,references |

+-------+--------------+------+-----+---------+-------+---------------------------------+

[root@file bin]#

[root@file bin]# pwd

/usr/local/mysql/bin

[root@file bin]# ./mysql -u root -p temp_db2

Enter password: ********

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 38 to server version: 4.0.14

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

mysql> show columns from temptable;

+-------+--------------+------+-----+---------+-------+

| Field | Type         | Null | Key | Default | Extra |

+-------+--------------+------+-----+---------+-------+

| uid   | mediumint(3) |      | PRI | 0       |       |

| name  | varchar(12)  |      |     |         |       |

+-------+--------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

mysql>