![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
相关问题
CODE: DROP TABLE IF EXISTS sg_search_log; CREATE TABLE sg_search_log( id smallint(6) unsigned NOT NULL auto_increment, ip varchar(15) NOT NULL default '', access_time int(10) unsigned NOT NULL default '0', PRIMARY KEY(id), KEY ip(ip) )TYPE=HEAP MAX_ROWS=4; |
mysql> select * from sg_search_log;
+----+-----------------+-------------+
| id | ip | access_time |
+----+-----------------+-------------+
| 1 | 101.210.321.520 | 111111111 |
| 2 | 101.210.321.520 | 111111111 |
| 3 | 101.210.321.520 | 111111111 |
| 4 | 101.210.321.520 | 111111111 |
| 5 | 101.210.321.520 | 111111111 |
| 6 | 101.210.321.520 | 111111111 |
| 7 | 101.210.321.520 | 111111111 |
| 8 | 101.210.321.520 | 111111111 |
| 9 | 101.210.321.520 | 111111111 |
| 10 | 101.210.321.520 | 111111111 |
| 11 | 101.210.321.520 | 111111111 |
| 12 | 101.210.321.520 | 111111111 |
| 13 | 101.210.321.520 | 111111111 |
| 14 | 101.210.321.520 | 111111111 |
| 15 | 101.210.321.520 | 111111111 |
| 16 | 101.210.321.520 | 111111111 |
| 17 | 101.210.321.520 | 111111111 |
| 18 | 101.210.321.520 | 111111111 |
| 19 | 101.210.321.520 | 111111111 |
+----+-----------------+-------------+
19 rows in set (0.00 sec)
MAX_ROWS=4像是没起作用
提问者:风在芯中 08-21 16:04
答复

