三个"?"代表变量,后面要传值进去的.
在mysql下的例子见如下:
mysql> create table cc(id int not null auto_increment primary key,
-> name varchar(20) not null,date timestamp default now());
Query OK, 0 rows affected (0.08 sec)mysql> desc cc;
+-------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | | |
| date | timestamp | YES | | CURRENT_TIMESTAMP | |
+-------+-------------+------+-----+-------------------+----------------+
3 rows in set (0.03 sec)mysql> insert into cc(id,name) values(1,'tom');
Query OK, 1 row affected (0.00 sec)mysql> select * from cc;
+----+------+---------------------+
| id | name | date |
+----+------+---------------------+
| 1 | tom | 2006-09-28 14:00:25 |
+----+------+---------------------+
1 row in set (0.00 sec)mysql> update cc set name='jim';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0mysql> select * from cc;
+----+------+---------------------+
| id | name | date |
+----+------+---------------------+
| 1 | jim | 2006-09-28 14:00:25 |
+----+------+---------------------+
1 row in set (0.00 sec)mysql> prepare stmt from 'insert into cc values(?,?,?)';
Query OK, 0 rows affected (0.44 sec)
Statement preparedmysql> set @a=2;
Query OK, 0 rows affected (0.03 sec)mysql> set @b='john';
Query OK, 0 rows affected (0.03 sec)mysql> set @c=now();
Query OK, 0 rows affected (0.05 sec)mysql> execute stmt using @a,@b,@c;
Query OK, 1 row affected (0.11 sec)mysql> select * from cc;
+----+------+---------------------+
| id | name | date |
+----+------+---------------------+
| 1 | jim | 2006-09-28 14:00:25 |
| 2 | john | 2006-09-28 14:09:55 |
+----+------+---------------------+
2 rows in set (0.08 sec)
在mysql下的例子见如下:
mysql> create table cc(id int not null auto_increment primary key,
-> name varchar(20) not null,date timestamp default now());
Query OK, 0 rows affected (0.08 sec)mysql> desc cc;
+-------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | | |
| date | timestamp | YES | | CURRENT_TIMESTAMP | |
+-------+-------------+------+-----+-------------------+----------------+
3 rows in set (0.03 sec)mysql> insert into cc(id,name) values(1,'tom');
Query OK, 1 row affected (0.00 sec)mysql> select * from cc;
+----+------+---------------------+
| id | name | date |
+----+------+---------------------+
| 1 | tom | 2006-09-28 14:00:25 |
+----+------+---------------------+
1 row in set (0.00 sec)mysql> update cc set name='jim';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0mysql> select * from cc;
+----+------+---------------------+
| id | name | date |
+----+------+---------------------+
| 1 | jim | 2006-09-28 14:00:25 |
+----+------+---------------------+
1 row in set (0.00 sec)mysql> prepare stmt from 'insert into cc values(?,?,?)';
Query OK, 0 rows affected (0.44 sec)
Statement preparedmysql> set @a=2;
Query OK, 0 rows affected (0.03 sec)mysql> set @b='john';
Query OK, 0 rows affected (0.03 sec)mysql> set @c=now();
Query OK, 0 rows affected (0.05 sec)mysql> execute stmt using @a,@b,@c;
Query OK, 1 row affected (0.11 sec)mysql> select * from cc;
+----+------+---------------------+
| id | name | date |
+----+------+---------------------+
| 1 | jim | 2006-09-28 14:00:25 |
| 2 | john | 2006-09-28 14:09:55 |
+----+------+---------------------+
2 rows in set (0.08 sec)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货