mysql 问号(?) 预编译

mysql> prepare stmt_12345 from "select * from groups where id = ? and out_id = ?";
Query OK, 0 rows affected (0.00 sec)
Statement prepared


mysql> set @1=9;
Query OK, 0 rows affected (0.00 sec)


mysql> set @2=18;
Query OK, 0 rows affected (0.00 sec)


mysql> EXECUTE stmt_12345 USING @1,@2;
+----+---------+-------------------------------------+-------------+--------------+--------+---------------------+---------------------+
| id   | name  | notification_nums                 | service_num | member_count | out_id | created_at          | updated_at          |
+----+---------+-------------------------------------+-------------+--------------+--------+---------------------+------