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';
用这一条数据,我删了很久,都没有反映,请问一下,我该怎么操作一下,实现我的需求。
解决方案 »
- 坐等simplexml_load_file解析xml问题?怎么便利出child下的内容
- 生成png图片的问题
- 各位PHPer,你们都用何种编译器啊?答者有分!
- 好怪的问题
- mvc的问题
- Parse error: syntax error, unexpected '0' (T_LNUMBER) in F:\wamp\www\book_club\v
- 我想学PHP,不知道需要多久才能做出类似商业网站的程序?
- date问题
- 请 phpteam(我忍住不哭) 过来领分,感谢你在“如何定时发送邮件”问题上对我的帮助!
- 急急急,我又碰到大麻烦了!~?
- 请教大家下,php怎么获取网页内容呀?和普通的不一样.!!!!!
- 小妹请教phpExcelReader读取中文excel文件出错问题
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;这样呢?