SET @param1 = '1705978360436793347';
SET @param2 = '1705978360571011075,1705978360696840194,1705978360763949059';
delete from tablename1 where FIND_IN_SET(id,@param2)>0 ;
update tablename2 set field1 = @param1 where FIND_IN_SET(field2,@param2)>0 ;
update tablename3 set field1 = @param1 where FIND_IN_SET(field1,@param2)>0 ;
SET @param3 = '1705978520713732098,1707957331068100610,1710222777456697345,1705978368959619074,1705978437272248323,1705978438132080643,1705978520113946626,1705978520646623234,1705978521049276418,1706237032995921922,1706950867704782850,1709471352392949761,1709742147367247874,1709867384092139521,1710182849783963650,1711211623078076417,1711284671324004353,1711571861367070721,1711685380607483905';
SELECT id FROM tablename1 WHERE FIND_IN_SET(id,@param3)>0;
通过设置参数,实现sql语句
于 2024-01-18 16:46:08 首次发布