EDIT: As given here: With no argument, LASTINSERTID() returns a 64-bit value. This behavior ensures that each client can retrieve its own ID without concern for the activity of other clients, and without the need for locks or transactions. Using the MySQL-specific method call isn't portable, and issuing a SELECT to get the AUTOINCREMENT key's value requires another. This value cannot be affected by other clients, even if they generate AUTOINCREMENT values of their own.

my sql scheme for the table is as follows: create table products(idnumber int(11) not null autoincrement, title varchar(255)): when i try inserting something.

Let us create a table with name sales in MySQL database, with one of the columns as auto-incremented, using CREATE statement as shown below − CREATE TABLE Sales(įollowing JDBC program establishes a connection with the database and inserts 5 records into the sales table − import java.sql. With older JDBC drivers for MySQL, you could always use a MySQL-specific method on the Statement interface, or issue the query SELECT LASTINSERTID() after issuing an INSERT to a table that had an AUTOINCREMENT key. Hi, im currently having some probs with an auto incrementing table in mysql. / Connector/ODBC Notes and Tips / Connector/ODBC General Functionality / Obtaining Auto-Increment Values 8.1.1 Obtaining Auto-Increment Values Obtaining the value of column that uses AUTOINCREMENT after an INSERT statement can be achieved in a number of different ways.

While inserting data into a table with auto-incremented column, just leave that particular column out and insert remaining values by specifying the remaining columns using the following syntax of the INSERT statement − INSERT into table_name (column_name1, column_name2.) values(value1, value2.) Example

Mysql jdbc get auto increment value