The-SleePy-Laptop:~ jeremy$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 819
Server version: 5.1.25-rc MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use smf_svn__7502;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show full columns from smf_log_search_subjects;
+----------+-----------------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+----------+-----------------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| word | varchar(20) | utf8_general_ci | NO | PRI | | | select,insert,update,references | |
| id_topic | mediumint(8) unsigned | NULL | NO | PRI | 0 | | select,insert,update,references | |
+----------+-----------------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
2 rows in set (0.00 sec)
mysql> show keys from smf_log_search_subjects;
+-------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| smf_log_search_subjects | 0 | PRIMARY | 1 | word | A | 3 | NULL | NULL | | BTREE | |
| smf_log_search_subjects | 0 | PRIMARY | 2 | id_topic | A | 3 | NULL | NULL | | BTREE | |
| smf_log_search_subjects | 1 | id_topic | 1 | id_topic | A | 1 | NULL | NULL | | BTREE | |
+-------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
3 rows in set (0.00 sec)