mysql
okela1985851010
本科毕业,ruby程序员.
展开
-
<<MySQL性能调优与架构设计>>
一,基础篇MySQL的基本架构[img]http://dl.iteye.com/upload/attachment/294650/6891112f-fac1-3605-ad61-7803986575b2.png[/img]SQL Layer中的子模块[img]http://dl.iteye.com/upload/attachment/294655/cd001272-183b-3a3...原创 2010-08-17 21:44:57 · 101 阅读 · 0 评论 -
order by null
mysql> explain select name from t1 where id>100 group by id,name\g;+----+-------------+-------+------+---------------+------+---------+------+------+----------------------------------------------+...原创 2010-09-16 23:24:32 · 93 阅读 · 0 评论 -
API
[quote]http://dev.mysql.com/[/quote][quote]A similar MySQL extension applies to the HAVING clause. Standard SQL does not permit the HAVING clause to name any column not found in the GROUP BY clause ...原创 2011-06-28 17:26:56 · 104 阅读 · 0 评论 -
工作记录(待续)
1,增加一个Sql远程登录用户[code="sql"]SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;GRANT select ON endysis.* TO eshop@localhost IDENTIFIED BY 'abc';GRANT select ON ...原创 2013-03-14 17:00:49 · 124 阅读 · 0 评论