实际上,不可能准备所有的 sql 语句,因为 Mysql 只允许准备以下几种 SQL 语句:SELECT 语句示例mysql> PREPARE stmt FROM 'SELECT tender_value fr
实际上,不可能准备所有的 sql 语句,因为 Mysql 只允许准备以下几种 SQL 语句:
mysql> PREPARE stmt FROM 'SELECT tender_value from Tender WHERE
Companyname = ?';
Query OK, 0 rows affected (0.09 sec)
Statement prepared
mysql> SET @A = 'Singla Group.';
Query OK, 0 rows affected (0.00 sec)
mysql> EXECUTE stmt using @A;
+--------------+
| tender_value |
+--------------+
| 220.255997 |
+--------------+
1 row in set (0.07 sec)
mysql> DEALLOCATE PREPARE stmt;
Query OK, 0 rows affected (0.00 sec)
修改数据的语句。
mysql> PREPARE stmt1 FROM 'DELETE from Tender WHERE Sr = ?';
Query OK, 0 rows affected (0.00 sec)
Statement prepared
mysql> SET @A = 4;
Query OK, 0 rows affected (0.00 sec)
mysql> EXECUTE stmt1;
ERROR 1210 (HY000): Unknown error 1210
mysql> EXECUTE stmt1 using @A;
Query OK, 1 row affected (0.08 sec)
mysql> DEALLOCATE PREPARE stmt1;
Query OK, 0 rows affected (0.00 sec)
mysql> Select * from tender;
+----+---------------+--------------+
| Sr | CompanyName | Tender_value |
+----+---------------+--------------+
| 1 | Abc Corp. | 250.369003 |
| 2 | Khaitan Corp. | 265.588989 |
| 3 | Singla group. | 220.255997 |
+----+---------------+--------------+
3 rows in set (0.00 sec)
mysql> PREPARE stmt3 FROM 'CREATE TABLE Student(Id INT, Name
Varchar(20))';
Query OK, 0 rows affected (0.00 sec)
Statement prepared
mysql> EXECUTE stmt3;
Query OK, 0 rows affected (0.73 sec)
mysql> DEALLOCATE PREPARE stmt3;
Query OK, 0 rows affected (0.00 sec)
mysql> PREPARE stmt10 FROM 'SHOW TABLES';
Query OK, 0 rows affected (0.00 sec)
Statement prepared
mysql> EXECUTE stmt10;
+-------------------+
| Tables_in_query |
+-------------------+
| emp |
| emp123 |
| emp_t |
| examination_btech |
| new_number |
| student |
| student_detail |
| student_info |
| tender |
| WEBsite |
+-------------------+
10 rows in set (0.00 sec)
--结束END--
本文标题: 什么样的SQL语句可以用来准备语句?
本文链接: https://lsjlt.com/news/436631.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0