DROP PROCEDURE IF EXISTS demoSp;   
CREATE PROCEDURE demoSp()
BEGIN
    set @sqlstr=concat("select count(*) from ", "dual");
    prepare stmt from @sqlstr;
    EXECUTE stmt;         
    deallocate prepare stmt;    
END;