Top "Insert-id" questions

How to get the insert ID in JDBC?

I want to INSERT a record in a database (which is Microsoft SQL Server in my case) using JDBC in …

java sql jdbc insert-id

MySQL ON DUPLICATE KEY - last insert id?

I have the following query: INSERT INTO table (a) VALUES (0) ON DUPLICATE KEY UPDATE a=1 I want the ID of …

mysql insert-id

Insert date and time into Mysql

I am trying to insert date and time into mysql datetime field. When a user select a date and time, …

php mysql datetime date insert-id

zend framework get last insert id of multi row insert using execute

How would I get the last inserted ID using a multirow insert? Here is my code: $sql='INSERT INTO t (…

zend-framework insert-id

mysqli->insert_id on update (PHP)

Does it work for anyone? :P I can properly get insert_id while inserting, but not on update. Of course …

php mysql mysqli insert-id