News:

Please note these forums are mostly a testing ground for my SMF work and I don't really use them otherwise.

Main Menu

Paste-1221525021:v:use_geshi-1:v:type-text

Started by SleePy, Sep 16, 2008, 12:30 AM

Previous topic - Next topic

0 Members and 3 Guests are viewing this topic.

SleePy

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)


No siggy! :D