å
说ä¸ä¸ SQL Server
éè¿ IDENTITY æ¥è®¾ç½®
åæ°æ2个ï¼ä¸ä¸ªæ¯âåå§å¼â ä¸ä¸ªæ¯âå¢éâã
é»è®¤æ
åµä¸ INSERT è¯å¥ä¸ï¼ä¸è½å¯¹ IDENTITY çå段è¿è¡èµå¼ã
å¯¹äº IDENTITY çå SQL Server å¨ INSERT çæ¶åï¼ä¼èªå¨å¿½ç¥æã
1> CREATE TABLE test_create_tab2 (
2> id INT IDENTITY(1, 1) PRIMARY KEY,
3> val VARCHAR(10)
4> );
5> go
1> INSERT INTO test_create_tab2(val) VALUES ('NO id');
2> go
(1 è¡åå½±å)
1> INSERT INTO test_create_tab2(id, val) VALUES (6, 'id no use');
2> go
æ¶æ¯ 544ï¼çº§å« 16ï¼ç¶æ 1ï¼æå¡å¨ HOME-BED592453C\SQLEXPRESSï¼ç¬¬ 1 è¡
å½ IDENTITY_INSERT 设置为 OFF æ¶ï¼ä¸è½ä¸ºè¡¨ 'test_create_tab2' ä¸çæ è¯åæå
¥æ¾å¼å¼ã
1> INSERT INTO test_create_tab2(val) VALUES ('A');
2> INSERT INTO test_create_tab2(val) VALUES ('B');
3> INSERT INTO test_create_tab2 VALUES ('C');
4> INSERT INTO test_create_tab2 VALUES ('D');
5> go
1> SELECT * FROM test_create_tab2;
2> go
id val
----------- ----------
1 NO id
2 A
3 B
4 C
5 D
(5 è¡åå½±å)
å说ä¸ä¸ mysql
éè¿
AUTO_INCREMENT设置
SQL INSERTè¯å¥çæ¶åï¼è¦é¿å
æå®é£ä¸ªèªå¢çå段
mysql> CREATE TABLE test_create_tab2 (
-> id INT AUTO_INCREMENT,
-> val VARCHAR(10),
-> PRIMARY KEY (id)
-> );
Query OK, 0 rows affected (0.09 sec)
mysql> INSERT INTO test_create_tab2(val) VALUES ('NO id');
Query OK, 1 row affected (0.03 sec)
mysql> select last_insert_id() as id;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.00 sec)
mysql> INSERT INTO test_create_tab2(val) VALUES ('NO id 2');
Query OK, 1 row affected (0.03 sec)
mysql> select last_insert_id() as id;
+----+
| id |
+----+
| 2 |
+----+
1 row in set (0.00 sec)
mysql> select * from test_create_tab2;
+----+---------+
| id | val |
+----+---------+
| 1 | NO id |
| 2 | NO id 2 |
+----+---------+
2 rows in set (0.00 sec)
温馨提示:答案为网友推荐,仅供参考