mysql> desc page;
+-------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+----------------+
| page_id | int(8) unsigned | NO | PRI | NULL | auto_increment |
| page_namespace | int(11) | NO | MUL | NULL | |
| page_title | varchar(255) | NO | | NULL | |
| page_restrictions | tinyblob | NO | | NULL | |
| page_counter | bigint(20) unsigned | NO | | 0 | |
| page_is_redirect | tinyint(1) unsigned | NO | | 0 | |
| page_is_new | tinyint(1) unsigned | NO | | 0 | |
| page_random | double unsigned | NO | MUL | NULL | |
| page_touched | char(14) | NO | | | |
| page_latest | int(8) unsigned | NO | | NULL | |
| page_len | int(8) unsigned | NO | MUL | NULL | |
+-------------------+---------------------+------+-----+---------+----------------+
11 rows in set (0.18 sec)
mysql> select * from page where page_title like '一个查找引起%';
+---------+----------------+---------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
| page_id | page_namespace | page_title | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random | page_touched | page_latest | page_len |
+---------+----------------+---------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
| 9968 | 0 | 一个查找引起latch_free的脚本 | | 16 | 0 | 1 | 0.909641285984 | 20090409164502 | 17533 | 726 |
+---------+----------------+---------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
1 row in set (0.12 sec)
阅读(1044) | 评论(0) | 转发(0) |