![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
heyun51
一条懒蛇,现在正在实习
展开
-
mysql 5.0,命令行导入乱码解决
正常使用: mysql -u xiao -p // 登录mysql use meiye_sns // 进入指定数据库(meiye_sns) \. uch_20090924.sql // 运行sql语句 如果数据出现乱码,就应该在运行sql语句前,指定编码(跟sql文件一至) mysql -u xiao -p // 登录mysql use meiye_sns //...原创 2009-09-24 09:23:40 · 123 阅读 · 0 评论 -
ON DUPLICATE KEY UPDATE (存在更新,否则添加)
INSERT INTO `iic_stat` (`sid`, `xid`, `mon`, `stype`, `d1`) VALUES (NULL, 7, 12345678, 'p', 0) ON DUPLICATE KEY UPDATE `d1` = `d1`+1 xid, mon, stype 设定为UNIQUE mysql 语句:当xid, mon, stype任意一个字段的值...原创 2010-01-06 14:01:27 · 2310 阅读 · 0 评论 -
mysql的FIND_IN_SET
select * from uchome_thread_ext a where FIND_IN_SET('p',a.tag) > 0 AND FIND_IN_SET('s',a.tag) > 0 a.tag字段值是('m','h','l','p','s') FIND_IN_SET(str,strlist) 如果字符串str在由N子串组成的表strlist之中,返回一个1...2009-08-25 17:59:12 · 115 阅读 · 0 评论 -
sql 表复制(不会重复数据)
insert into `blog_type` (`blogid`,`classid`,`att`,`stime`,`etime`) select b.`blogid`,6,'c,h','2009-08-31 15:00:00', '2009-09-05 15:00:00' from `uchome_blog` b where b.`blogid` NOT IN (SELECT t.`blogid...原创 2009-08-31 09:58:08 · 192 阅读 · 0 评论 -
mysql 随机查询,,效率优化
select * from bl_keylist where Title like '%bags%' or Title like '%handbags%' order by rand() limit 0,12 效率太低了点。。换成这样SELECT * FROM bl_keylist AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MA...原创 2010-09-10 15:49:26 · 101 阅读 · 0 评论 -
opencart 删除重复的产品的sql
DELETE p.*, pd.*, pc.*, p2s.*, m.*, ss.* FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)...原创 2011-06-08 10:06:05 · 191 阅读 · 0 评论 -
删除数据库重复数据
delete from tableName where rowname in (select rowname from tableName group by rowname having count(rowname) > 1) and rowid not in (select min(rowid) from tableName group by rowname having count(ro...原创 2012-03-10 04:30:58 · 85 阅读 · 0 评论