call adduser('fengyu', 0x6d1cf88c4543d51a1a234745b6014e20)
uj5u.com熱心網友回復：
select @@identity; 放在insert陳述句后面，可以獲取到自增的id
mysql> create table t4(id int auto_increment,name varchar(100),primary key (id));
Query OK, 0 rows affected (0.02 sec)
mysql>
mysql> insert into t4(name) values ('test');
Query OK, 1 row affected (0.01 sec)
mysql>
mysql> select @@identity;
+------------+
| @@identity |
+------------+
| 1 |
+------------+
1 row in set (0.00 sec)
mysql> select * from t4;
+----+------+
| id | name |
+----+------+
| 1 | test |
+----+------+
1 row in set (0.00 sec)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/7148.html
標籤：MySQL