Se sidste indtasting

Hvis det er auto genereret så:

SELECT LAST_INSERT_ID()

hvis det er manuelt indtastet skal du have et kriterie at finde det på.

Fik lige trykket lidt for hurtig
skulle have været: SELECT LAST_INSERT_ID() FROM tabel
SE:
http://dev.mysql.com/doc/mysql/en/Information_functions.html

The last ID that was generated is maintained in the server on a per-connection basis. This means the value the function returns to a given client is the most recent AUTO_INCREMENT value generated by that client. The value cannot be affected by other clients, even if they generate AUTO_INCREMENT values of their own. This behavior ensures that you can retrieve your own ID without concern for the activity of other clients, and without the need for locks or transactions. The value of LAST_INSERT_ID() is not changed if you update the AUTO_INCREMENT column of a row with a non-magic value (that is, a value that is not NULL and not 0). If you insert many rows at the same time with an insert statement, LAST_INSERT_ID() returns the value for the first inserted row. The reason for this is to make it possible to easily reproduce the same INSERT statement against some other server. If you use INSERT IGNORE and the record is ignored, the AUTO_INCREMENT counter still is incremented and LAST_INSERT_ID() returns the new value. If expr is given as an argument to LAST_INSERT_ID(), the value of the argument is returned by the function and is remembered as the next value to be returned by LAST_INSERT_ID(). This can be used to simulate sequences:


eller
se evt. http://www.eksperten.dk/spm/467742

Øh.

Hvis man læser dit link så ser man netop at min syntax:

SELECT LAST_INSERT_ID()

er korrekt og at man ikke skal bruge din syntax:

SELECT LAST_INSERT_ID() FROM tabel

...

øøøhhh ja hvad skete der lige her ! jeg tro at jeg har blandet 2 spørgsmål sammen, jeg beklager

Lukker