liuwang888的专栏

mysql:SELECT * FROM EVENT WHERE eventId IN(443,419,431,440,420,414,509)  ORDER BY INSTR(',443,419,431,440,420,414,509,',CONCAT(',',eventId,',')) oracle:select name from order where oderid in（...

QuestionAnswer表Login表  SELECT an.`answerId`,an.`loginId`,an.`ipAddress`,lg.viewName FROM `QuestionAnswer` as an,Login as lg where lg.loginId = an.loginId and `surveyId` = 14 QuestionAnswer表中有l...

select * from SiteMailManager smm where TIMESTAMPDIFF(second,'2012-07-03',smm.sendTimestamp)>0 sendTimestamp是当天的记录,即sendTimestamp减before argument大于0 update ManagerMail set  sendSms=case whe...

批量Update,从另一个表中取关联的字段对应的值,来更新当前的表的joinCount值 UPDATE EventGroup g SET joinCount =(SELECT b.counts FROM (SELECT eventGroupId,SUM(1) AS counts FROM EventGroupMember WHERE groupRoleId<4 AND (memb...

CASE WHEN (t.payWay =10 OR t.payWay =11) AND t.payStatus=1  THEN CAST(tod.totalPrice AS DECIMAL(10,2)) CASE WHEN (t.payWay =10 OR t.payWay =11) AND t.payStatus=0 THEN   ELSE CAST((tod.totalPrice-(tod....

sql语句中left join、inner join中的on与where的区别table a(id, type):id     type----------------------------------1      1        2      1         3      2         table b(id, class):id    clas...

 mysql 多行变一行　若行与列转换2008-10-16 09:42 345人阅读 评论(0) 收藏 举报 DateClass       Class         Count     2004-02             AU                 32     2004-02             VAIO             56     20...