一个动态SQL的例子
出处:mysqlpub.com一个拼表名参数的例子(表名不能被参数化):DELIMITER $$USE `TestDB`$$DROP PROCEDURE IFEXISTS `USP_kider`$$CREATEDEFINER=`admin`@`%` PROCEDURE`USP_kider`(v_TableNameVARCHAR(64))BEGINPREPAREkidersql FROM 'select * from ?';SET@tableName=v_TableName;EXECUTEkidersql USING @tableName; END$$DELIMITER ;
页:
[1]