qq_37766224的博客

ALTER TABLE `表名` ADD UNIQUE(`字段名`);

selece * from table A 时取别名A有利于下次嵌套一层select大神的sqlSELECT   *FROM  (SELECT     @ROWNUM := @ROWNUM + 1 AS ROWNUM,    H.*   FROM    qc_approval_history H,    (SELECT       @ROWNUM := 0) A w...

SELECT D.*FROM ( SELECT * FROM ( SELECT * FROM ( SELECT @ROWNUM := @ROWNUM + 1 AS ROWNUM, H.* FROM qc_approval_history H, (SELEC...

加密方式 eg: cmd进入 jasypt 目录，执行 java -cp jasypt-1.9.2.jar org.jasypt.intf.cli.JasyptPBEStringEncryptionCLI password=G0CvDz7oJn6 algorithm=PBEWithMD5AndDES input=!@Epp_usr123

以下红色为字段名1.concat()函数修改mysql可以多个参数，oracle只能两个参数，嵌套mysql<if test="address != null and address != ''"> AND xu.ADDRESS like concat('%',#{address,jdbcType=VARCHAR},'%')</if>oracle...