sql
wdgkw
这个作者很懒,什么都没留下…
展开
-
sql语句在insert时 有‘ ’
Parameter index out of range (1 > number of parameters, which is 0).原创 2015-11-18 13:25:56 · 455 阅读 · 0 评论 -
sql数据密文显示
SELECT *,CONCAT('*',SUBSTR(u.member_id, 1,1),'**') as member_ids from user as u INNER ma_member AS m ON m.member_id=u.member_id原创 2016-01-13 15:47:04 · 667 阅读 · 0 评论 -
批量插入
传入一个list集合:VALUESforeach collection="list变量" item="item" index="index" separator=","> (#{item.batch_no}, #{item.remark}, #{item.customer_name}, #{item.id_type}, foreach>原创 2016-07-15 14:05:24 · 188 阅读 · 0 评论 -
CONCAT(SUBSTRING(m.USER_NAME,1,1),'***') AS `USER_NAME`
CONCAT(SUBSTRING(m.USER_NAME,1,2),'***') AS `USER_NAME`substring截取 从左边第一位,往后截取2位concat 连接符,原创 2016-09-18 16:45:13 · 639 阅读 · 0 评论