RosettaCodeData/Task/Parameterized-SQL-statement/MariaDB/parameterized-sql-statement-2.sql

9 lines
264 B
MySQL
Raw Permalink Normal View History

2024-10-16 18:07:41 -07:00
BEGIN NOT ATOMIC
DECLARE customer_1 TEXT DEFAULT 24;
DECLARE customer_2 TEXT DEFAULT 777;
PREPARE stmt FROM 'SELECT * FROM customer WHERE id = ?';
EXECUTE stmt USING customer_1;
EXECUTE stmt USING customer_2;
DEALLOCATE PREPARE stmt;
END;