数据库中将一个表中内容整理后插入到另外一张表中的sql语句
INSERT INTO b_salemarketmessagepush (B_SALEMARKETID, TYPE,CONTENT)
select id, "3",CONCAT(name,'未在规定时间内上传公示快检信息,请及时上传。') from b_salemarket
先筛选一张表后在另外一张表中删除此查询信息sql语句
DELETE
FROM
b_checkinfoqualitative
WHERE
b_checkinfoqualitative.ID IN (
select a.id from (
SELECT
ID
FROM
b_checkinfoqualitative bc
WHERE
bc.C_THIRDCOMPANY = 57
AND bc.CHECKDATE <= "2018-12-13"
)a
)
先筛选一张表后在另外一张表中修改此查询信息sql语句
UPDATE b_salemarket
SET b_salemarket.ISUPLOAD = '0'
WHERE
b_salemarket.id IN (
SELECT
a.id
FROM
(
SELECT
bs.ID
FROM
b_salemarket bs
WHERE
bs.`NAME` IN (
'新昌县新南综合农贸市场',
'新昌县上礼泉农贸综合市场'
)
) a
)
修改sql的一些使用
update a_goodsalias as ag , (select id from a_goodsalias
where gb_code in(select code from a_goodsinfo_szcp)) as b
set ag.gb_code = '211100112'
where ag.id = b.id