sid | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| userid | int(10) unsigned | NO | MUL | 0 | |
| sip | bigint(12) unsigned zerofill | NO | MUL | NULL | |
| stime | int(10) unsigned | NO | MUL | NULL | |
| stype | tinyint(1) unsigned | NO | MUL | NULL | |
| keyword | char(80) | NO | MUL | NULL |
DELETE FROM search WHERE stime<='1325350861';
用这一条数据,我删了很久,都没有反映,请问一下,我该怎么操作一下,实现我的需求。
| userid | int(10) unsigned | NO | MUL | 0 | |
| sip | bigint(12) unsigned zerofill | NO | MUL | NULL | |
| stime | int(10) unsigned | NO | MUL | NULL | |
| stype | tinyint(1) unsigned | NO | MUL | NULL | |
| keyword | char(80) | NO | MUL | NULL |
DELETE FROM search WHERE stime<='1325350861';
用这一条数据,我删了很久,都没有反映,请问一下,我该怎么操作一下,实现我的需求。
mysql> delete from bit_dcsval where insert_datetime<'2009-10-01' order by insert_datetime limit 10000;
Query OK, 10000 rows affected, 1 warning (3 min 48.40 sec)上面是网上的例子
TRUNCATE TABLE search;
INSERT INTO search SELECT * FROM search_tmp;
把数据导入进原表出错。
RENAME TABLE search_tmp TO search;这样呢?