Question

有些人可以解释一下MySQL如何运作LAST_INSERT_ID(ID)。 I m试图在数据库中 last上最后插入一行,但每次都有1台。

我使用我的施舍。

例:

<insert id="insertInto" parameterType="Something" timeout="0">
  INSERT INTO something (something) VALUES (#{something})
  <selectKey resultType="int">
    SELECT LAST_INSERT_ID()
  </selectKey>
</insert>

法典:

System.out.println("Id : " + id)

产出:

Id : 1

Answer 1

<代码>LAST_INSERT_ID 回到最后数值简单明了插入。AUTO_INCREMENT 页: 1

CREATE TABLE mytable (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, value INT NOT NULL);

为了使该栏自动增加,请从<代码>中删除。 INSERT list:

INSERT
INTO    mytable (value)
VALUES  (1)

或向其提供<条码>。价值:

INSERT
INTO    mytable (id, value)
VALUES  (NULL, 1)

之后,

SELECT  LAST_INSERT_ID()

页: 1 缩略语

如果:

You provide the explicit value for the AUTO_INCREMENT column
You call LAST_INSERT_ID in another session
You insert more than one row in the same statement (LAST_INSERT_ID() will return the value of the first row inserted, not the last one).

Answer 2

LAST_INSERT_ID()

每个用户和每个链接。

可在

Answer 3

我用了MyBatis,但在你在表格中添加一些内容之后,我检查了MySQL的汽车增益价值。

SELECT Auto_increment FROM (SHOW TABLE STATUS LIKE  <table-name> ) as A;

还确保你对<条码>auto_increment领域没有明确的价值。你们需要让亚洲开发银行为自己确定。

在这里,你可以尝试其他一些事情:

确保你将结果作为分类。。

If you re doing multiple inserts, know that only the ID of the first inserted tuple is treated as the LAST_INSERT_ID. According to this (Search for use test).

Answer 4

I have two solutions, after implements much complicated i find out about second one... I will tell you second which is better one ... It s pretty simple... just in query insert this keyProperty="id" Like this : <insert id="insertInto" parameterType="Something" keyProperty="id" timeout="0"> INSERT INTO something (something) VALUES (#{something}) </insert> Query returns id of inserted row Thanks!

Answer 5

例1:

mysql> CREATE TABLE prime2 LIKE prime;
Query OK, 0 rows affected (0.08 sec)

mysql> SELECT LAST_INSERT_ID(); //From table prime!!!
+------------------+
| LAST_INSERT_ID() |
+------------------+
|                3 |
+------------------+
1 row in set (0.00 sec)


mysql> INSERT INTO prime2 VALUES(1,1);
Query OK, 1 row affected (0.01 sec)

mysql> SELECT LAST_INSERT_ID(); 
+------------------+
| LAST_INSERT_ID() |
+------------------+
|                3 |
+------------------+
1 row in set (0.00 sec) //From table prime!!!

Answer 6

You have to use a Table name to select the last insert id.

例:

SELECT LAST_INSERT_ID() FROM my_table;

友情链接