Tag Archives: mysql variable

For prepared statements, you can use placeholders (supported as of MySQL version 5.0.7). The following statements will return one row from the tbl table: SET @a=1; PREPARE STMT FROM ‘SELECT * FROM tbl LIMIT ?’; EXECUTE STMT USING @a; The … Continue reading →