Pass two value to prepare
mysql> mysql> mysql> mysql> CREATE TABLE TEAMS -> (TEAMNO INTEGER NOT NULL, -> EmployeeNO INTEGER NOT NULL, -> DIVISION CHAR(6) NOT NULL, -> PRIMARY KEY (TEAMNO) ); Query OK, 0 rows affected (0.00 sec) mysql> mysql> mysql> INSERT INTO TEAMS VALUES (1, 6, 'first'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO TEAMS VALUES (2, 27, 'second'); Query OK, 1 row affected (0.00 sec) mysql> mysql> PREPARE S3 FROM 'SELECT * FROM TEAMS WHERE TEAMNO BETWEEN ? AND ?' ; Query OK, 0 rows affected (0.00 sec) Statement prepared mysql> mysql> SET @FROM_TNO = 1, @TO_TNO = 4; Query OK, 0 rows affected (0.00 sec) mysql> mysql> EXECUTE S3 USING @FROM_TNO, @TO_TNO; +--------+------------+----------+ | TEAMNO | EmployeeNO | DIVISION | +--------+------------+----------+ | 1 | 6 | first | | 2 | 27 | second | +--------+------------+----------+ 2 rows in set (0.00 sec) mysql> mysql> DEALLOCATE PREPARE S3; Query OK, 0 rows affected (0.00 sec) mysql> mysql> drop table teams; Query OK, 0 rows affected (0.00 sec) mysql> mysql> mysql> mysql> mysql> CREATE TABLE EVENTS_INVOKED -> (EVENT_NAME VARCHAR(20) NOT NULL, -> EVENT_STARTED TIMESTAMP NOT NULL); Query OK, 0 rows affected (0.00 sec)
1. | Prepare command | ||
2. | Pass value to sql with prepare |