tencent cloud

문서TDSQL for MySQL

Preprocessing

포커스 모드
폰트 크기
마지막 업데이트 시간: 2024-01-06 17:34:55
Supported SQL syntax:
PREPARE Syntax
EXECUTE Syntax
Supported binary protocols:
COM_STMT_PREPARE
COM_STMT_EXECUTE
Sample:
mysql> select * from test1;
+---+------+
| a | b |
+---+------+
| 5 | 6 |
| 3 | 4 |
| 1 | 2 |
+---+------+
3 rows in set (0.03 sec)
mysql> prepare ff from "select * from test1 where a=?";
Query OK, 0 rows affected (0.00 sec)
Statement prepared

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

mysql> execute ff using @aa;
+---+------+
| a | b |
+---+------+
| 3 | 4 |
+---+------+
1 row in set (0.06 sec)

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백