可以通过以下示例来理解，在该示例中我们使用准备好的语句创建了名为“student”的表 -
mysql> prepare stmt3 from 'create table student(id int, namevarchar(20))';query ok, 0 rows affected (0.00 sec)statement preparedmysql> execute stmt3;query ok, 0 rows affected (0.73 sec)mysql> deallocate prepare stmt3;query ok, 0 rows affected (0.00 sec)
现在，在使用准备好的语句进行以下查询的帮助下，我们可以在表“student”中插入值
-
mysql> prepare stmt7 from 'insert into student(id,name) values(?,?)';query ok, 0 rows affected (0.00 sec)statement preparedmysql> set @a = 1, @b = 'ram';query ok, 0 rows affected (0.00 sec)mysql> execute stmt7 using @a, @b;query ok, 1 row affected (0.04 sec)mysql> set @a = 2, @b = 'shyam';query ok, 0 rows affected (0.00 sec)mysql> execute stmt7 using @a, @b;query ok, 1 row affected (0.08 sec)mysql> set @a = 3, @b = 'mohan';query ok, 0 rows affected (0.00 sec)mysql> select * from student;+------+-------+| id | name |+------+-------+| 1 | ram || 2 | shyam || 3 | mohan |+------+-------+3 rows in set (0.00 sec)
以上就是如何创建表并使用准备语句在该表中插入值？的详细内容。