SQL用法笔记

1.更改当前记录以外的数据的xh自动加1&＃xff08;MySQL字段为int&＃xff09;
String sql &＃61; "UPDATE t_readtext as tr SET xh &＃61; xh &＃43;1\n" &＃43;"WHERE readcourceId <> "&＃43; textbookId;
2.SQL CONCAT()函数作用是 返回的字符串参数连接的结果
工作的实例SQL代码如下
SELECT b1.displayname , b1.englishname , a1.ztsj , a1.textcns FROM ( SELECT cc.yhid, MAX(cc.yhda) as yhda , cc.ztsj, COUNT(cc.textbookid) textcns FROM ( SELECT a.yhid, MAX(a.yhda) as yhda , CONCAT(FLOOR(a.ztsj /86400) , &＃39;天&＃39;, FLOOR((a.ztsj /86400-FLOOR(a.ztsj /86400)) *24) , &＃39;时&＃39;, FLOOR(a.ztsj %3600/60) , &＃39;分&＃39; ) as ztsj, a.textbookid from t_yhzt a INNER JOIN t_xslgclass b on b.xsid &＃61; a.yhid WHERE b.bjid &＃61; 44 AND a.createdt>&＃61; DATE_SUB(CURDATE(),INTERVAL dayofyear(now())-1 DAY) GROUP BY a.yhid, a.textbookid)cc GROUP BY cc.yhid )a1 INNER JOIN t_yh b1 on b1.id &＃61; a1.yhid limit 2