Get the value of the last inserted record

Question

I am trying to get the stop_name of the last inserted row in the table with preparedStatement. How can I get the last inserted one?

I appreciate any help.

behavoiur table:

CREATE TABLE IF NOT EXISTS behaviour( behaviour_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, mac VARCHAR(30) NOT NULL, stop_name VARCHAR(30) NOT NULL, stop_distance INT(11) NOT NULL, speed INT(11) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

Are you asking help with writing the query or writing the code? — Kayaman
– Kayaman, Commented Jun 22, 2015 at 9:34

score 2 · Accepted Answer · 2015-06-22 10:02:28Z

2

You may try this query:

select stop_name from behaviour where created_at in (select max(created_at) from behaviour)

edited Jun 22, 2015 at 10:02

answered Jun 22, 2015 at 9:36

user2575725

Sign up to request clarification or add additional context in comments.

Comments

Radek Postołowicz · Accepted Answer · 2015-06-22 09:44:14Z

0

Another solution:

select stop_name from behaviour order by behaviour_id desc limit 1;

answered Jun 22, 2015 at 9:44

Radek Postołowicz

4,8742 gold badges32 silver badges52 bronze badges

Collectives™ on Stack Overflow

Get the value of the last inserted record

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related