How do I get the value of a new record's self-increment?

This is defined when the table is defined:

CREATE TABLE Room(    R_Id char(128) AUTO_INCREMENT PRIMARY KEY,    R_Info char(128) NOT NULL)

If I insert a record into the table:

INSERT INTO Room (R_Info) VALUES ("123456")

Is there any good way to get the value of the add-on r_id just inserted record?

Reply content:

This is defined when the table is defined:

CREATE TABLE Room(    R_Id char(128) AUTO_INCREMENT PRIMARY KEY,    R_Info char(128) NOT NULL)

If I insert a record into the table:

INSERT INTO Room (R_Info) VALUES ("123456")

Is there any good way to get the value of the add-on r_id just inserted record?

INSERT INTO Room (R_Info) VALUES ("123456");SELECT last_insert_id();

