mysql> prepare getpdo from 'select * from pdo where id=?';
ERROR 1146 (42S02): Table 'yanruicheng.pdo' doesn't exist
mysql> prepare getpdo from 'select * from class where id=?'
-> ;
Query OK, 0 rows affected (0.01 sec)
Statement prepared
mysql> set @id = 6;
Query OK, 0 rows affected (0.00 sec)
mysql> execute getpdo;
ERROR 1210 (HY000): Incorrect arguments to EXECUTE
mysql> execute getpdo using @id;
+----+--------+--------+--------+-------+
| id | same | gender | salary | funbu |
+----+--------+--------+--------+-------+
| 6 | 刘备 | 男 | 8000 | 1.00 |
+----+--------+--------+--------+-------+
1 row in set (0.00 sec)
mysql> set @id=5;
Query OK, 0 rows affected (0.00 sec)
mysql> execute getpdo using @id;
+----+--------+--------+--------+-------+
| id | same | gender | salary | funbu |
+----+--------+--------+--------+-------+
| 5 | 刘备 | 男 | 8000 | 1.00 |
+----+--------+--------+--------+-------+
1 row in set (0.00 sec)
mysql> set @id=5 or 1;
Query OK, 0 rows affected (0.00 sec)
mysql> execute getpdo using @id;
+----+--------+--------+--------+-------+
| id | same | gender | salary | funbu |
+----+--------+--------+--------+-------+
| 1 | 刘备 | 男 | 8000 | 1.00 |
+----+--------+--------+--------+-------+
1 row in set (0.00 sec)
mysql>