Sql - 随笔分类 - ♥起风了♥

mybatis SQL语句

摘要：insert into 表名 <trim prefix="(" suffix=")" suffixOverrides=","> <if test="createTime != null"> CREATE_TIME, </if> </trim> <trim prefix="values (" suff 阅读全文

posted @ 2018-08-20 09:57 ♥起风了♥ 阅读(166) 评论(0) 推荐(0)

mysql查询设置行号ROW_NUMBER()

摘要：SELECT ROW_NUMBER() over ( order by 字段) from 表阅读全文

posted @ 2018-08-03 19:05 ♥起风了♥ 阅读(794) 评论(0) 推荐(0)

sql查询：根据中文拼音首字母查询

摘要：SELECT * FROM 表 order by 字段 collate Chinese_PRC_CI_AS 阅读全文

posted @ 2018-06-27 10:58 ♥起风了♥ 阅读(758) 评论(0) 推荐(0)

随笔分类 - Sql