[RESOLVED] Get newly inserted row

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

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.

Code:

---

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

---

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

Code:

---

                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.