MySQL预处理语句

PREPARE s1 FROM 'select * from event_table';/*预处理语句*/EXECUTE s1;DEALLOCATE PREPARE s1;/*删除预处理语句*/PREPARE S FROM 'select * from event_table where id = @id';/*使用变量的预处理语句*/SET @id=3;EXECUTE S;PREPARE S1 FROM 'select * from event_table where id between ? and ?';/*使用参数的预处理语句*/SET @from = 2,@to = 10;EXECUTE S1 USING @from ,@to;