![](https://img-blog.csdnimg.cn/20190918140129601.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
MySql
MySQL配置优化及编程
david2code
Keep Coding,Keep Foolish!
展开
-
MySQL删除表中重复数据及主键重新排列
MySQL删除表中重复数据及主键重新排列一、删除表中重复数据删除前:1234567891011mysql> select * from duplicate;+----+-------+| id | name |+----+-------+| 1 | wang || 3 |转载 2014-06-24 11:58:37 · 889 阅读 · 0 评论 -
mysql正则表达式实践
1、统计表中category为空且http_host为ip地址的行数。select count(*) from `log-http-5` where category = "" and http_host REGEXP "^([0-9]{1,3}\\.){3}([0-9]{1,3})(([:]([0-9]{1,})){0,1})$" limit 6;原创 2014-06-23 13:54:47 · 360 阅读 · 0 评论 -
mysql语句总结
select count(*) / ( select count(*) from `log-http-24` AS ass ) from `log-http-24` where category原创 2014-05-28 09:45:38 · 490 阅读 · 0 评论