[RESOLVED] Get newly inserted row

[hitai]

I`m using JDBC to connect to MySql. From my java code, I inserd new rows into the data table using INSERT statements. How can I get back the new inserted row? I`m leaving the fields to have their default values when inserting

[hspc]

Hello, you can use the last_insert_id() MySQL function (If you use an autoincrement columns as a PK) to get the PK value of the newly added record.

Select col1,col2 from tablename where id = last_insert_id()

And read this data from java like this: (I'm not a java expert)

		CallableStatement sql=con.prepareCall("call InsertAndGetValues()");
		
		ResultSet result = sql.executeQuery();
		
		if(result.first())
		{
			int x = result.getInt(1);
			String s = result.getString(2);
		}

InsertAndGetValues is the name of the stored procedure that you use to insert new recored and select its values as above.