Mega Code Archive

 

Categories / Java Tutorial / Database

 

Retrieve Automatically Generated Keys Using a Statement (MySQL)

mysql CREATE TABLE yourtable ( - id INT NOT NULL AUTO_INCREMENT, - name VARCHAR(32) NOT NULL, - PRIMARY KEY (id) - ); Solution stmt.executeUpdate("insert into yourtable (name) values('tiger')");     rs = stmt.getGeneratedKeys();