Hi Jacques!
> I'm working with a table that includes a field "id INTEGER AUTO-INCREMENT
> NOT NULL" .
>
> When I create a new record with the query "INSERT", I don't give any value
> for the id field, the value is automatically given by mySQL.
> As the database is supposed to be used on the WEB, several queries INSERT
> can happen simultaneously. How can know the value of the id field
> corresponding to the record that has been created by MY INSERT query ?
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
8.4.6.3 How Can I Get the Unique ID for the Last Inserted Row?
http://www.mysql.com/doc/G/e/Getting_unique_ID.html
Have a :) day!
jb
--
jim barchuk
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
