mysql 问号(?) 预编译

最新推荐文章于 2022-02-14 22:22:08 发布

原创最新推荐文章于 2022-02-14 22:22:08 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

16 篇文章

订阅专栏

本文介绍了MySQL中使用问号(?)作为预编译语句的占位符，通过示例展示了如何准备、设置参数和执行预编译的SQL语句，以提高查询效率和安全性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 |
+----+---------+-------------------------------------+-------------+--------------+--------+---------------------+---------------------+
| 9 | xxB | 11111111111,11111111 , | NULL | 0 | 18 | 2011-01-11 11:22:26 | 2011-01-11 16:22:26 |
+----+---------+-------------------------------------+-------------+--------------+--------+---------------------+---------------------+
1 row in set (0.00 sec)