Mybatis映射文件sql语句注意事项（个人笔记）

最新推荐文章于 2024-04-03 10:07:51 发布

我叫瘦企鹅

最新推荐文章于 2024-04-03 10:07:51 发布

阅读量447

点赞数

本文链接：https://blog.csdn.net/NullPoint_cm/article/details/78434048

版权

INSERT INTO ordersNew(goodName,goodNum,receiveAddress)
SELECT (SUBSTRING_INDEX(
SUBSTRING_INDEX(
SUBSTRING_INDEX(
goodsName,'）',1),'（',-1),'+', 1)),
(goodsNum<![CDATA[*]]>SUBSTRING_INDEX(fenNum,'+',1)),receiveAddress
FROM orders WHERE goodsName LIKE CONCAT ('%','#','%') AND goodsName
IN (SELECT o.goodsName FROM orders AS o WHERE (LENGTH(o.goodsName) -

LENGTH(REPLACE (o.goodsName, '+', '')))=1 AND goodsName LIKE CONCAT ('%','#','%'));

在XxMapper.xml中嵌入sql语句时*嘚用<![CDATA[*]]>进行处理