DELIMITER $$DROP PROCEDURE IF EXISTS `test`$$CREATE PROCEDURE `test`(IN ids varchar(36)) select
id
from tab_a
where id in (ids); END$$DELIMITER ;call test('1,2,3');
怎么样子查出id为1, 2 & 3的记录? 谢谢!
id
from tab_a
where id in (ids); END$$DELIMITER ;call test('1,2,3');
怎么样子查出id为1, 2 & 3的记录? 谢谢!
from tab_a
where instr(','+ids+',',','+id+',')>0;
性能的差别在这里
PREPARE stmt_name FROM @sql ;
EXECUTE stmt_name ;END$$ DELIMITER ; call test('1,2,3');