![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
iteye_20503
这个作者很懒,什么都没留下…
展开
-
mysql数据量过大,请创建字段索引
[size=large]当mysql 数据量超过百万时,在字段上创建索引是很有必要的。[/size] [img]http://dl.iteye.com/upload/attachment/601987/565510d9-972b-3f1e-b6c4-fd9623e1429c.png[/img] [img]http://dl.iteye.com/upload/attachment/6...原创 2011-12-07 21:49:54 · 205 阅读 · 0 评论 -
mysql 替换语句
将cdb_pms表subject字段中的Welcom to替换成 欢迎光临 UPDATE `cdb_pms` SET `subject` = REPLACE(`subject`, 'Welcome to', '欢迎光临') WHERE INSTR(`subject`,'Welcome to') > 0 替换cdb_posts表的message字段,将“viewthread.php?tid=...原创 2011-11-30 20:08:42 · 76 阅读 · 0 评论