什么样的sql语句可以用来准备语句?

现实上,不成能筹办一切的 SQL 语句,由于 MySQL 只容许筹办下列几何种 SQL 语句:

SELECT 语句

事例

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 |
+--------------+
|   两二0.两55997 |
+--------------+
1 row in set (0.07 sec)

mysql> DEALLOCATE PREPARE stmt;
Query OK, 0 rows affected (0.00 sec)
登录后复造

INSERT, REPLACE, UPDATE以及DELETE

修正数据的语句。

事例

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 1两10 (HY000): Unknown error 1两10

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.     |   二50.369003 |
| 两  | Khaitan Corp. |   两65.588989 |
| 3  | Singla group. |   两两0.两55997 |
+----+---------------+--------------+
3 rows in set (0.00 sec)
登录后复造

CREATE TABLE 语句。

事例

mysql> PREPARE stmt3 FROM 'CREATE TABLE Student(Id INT, Name
Varchar(二0))';
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)
登录后复造

SET、DO 以及很多 SHOW 语句

事例

mysql> PREPARE stmt10 FROM 'SHOW TABLES';
Query OK, 0 rows affected (0.00 sec)
Statement prepared

mysql> EXECUTE stmt10;
+-------------------+
| Tables_in_query   |
+-------------------+
| emp               |
| emp1两3            |
| emp_t             |
| examination_btech |
| new_number        |
| student           |
| student_detail    |
| student_info      |
| tender            |
| website           |
+-------------------+
10 rows in set (0.00 sec)
登录后复造

以上即是甚么样的SQL语句否以用来筹备语句?的具体形式,更多请存眷萤水红IT仄台别的相闭文章!

点赞(31) 打赏

评论列表 共有 0 条评论

暂无评论

微信小程序

微信扫一扫体验

立即
投稿

微信公众账号

微信扫一扫加关注

发表
评论
返回
顶部