MySQL :: Run SQL statement within Variable

Question

I am creating a stored procedure in MySQL 5.1.40 which needs to run a lot of SQL statements.

One particular statement that is often repeated clears a temp table:

DELETE FROM w_projection_temp WHERE user_id = uid;

The uid variable is an IN parameter for the SP.

Is it possible to assign that entire SQL statement to another variable, and then somehow run (evaluate?) that new variable? eg:

DECLARE clear_temp VARCHAR;
SET clear_temp = 'DELETE FROM w_projection_temp WHERE user_id = uid;'

MTIA

why do you want to make this dynamic - you got it right first time — Jon Black
– Jon Black, Commented Dec 15, 2010 at 5:10

rkg · Accepted Answer · 2010-12-15 04:15:39Z

2

PREPARE clear_temp FROM "DELETE FROM w_projection_temp WHERE user_id = ?"
EXECUTE clear_temp USING uid;
DEALLOCATE PREPARE clear_temp;

answered Dec 15, 2010 at 4:10

rkg

5,6849 gold badges39 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1