Last Inserted ID for MySQL.

[abhishek-hotstar]

CREATE TABLE IF NOT EXISTS student
(
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50) NOT NULL
);

/* name: InsertStudent :exec */
INSERT INTO student (name)
VALUES (?);

The result only returns an error, not the sql.Result. Only on the result pointer can we call LastInsertId(). Please suggest a way forward.

Thank you.

[aitva]

You can get an sql.Result by using the :execresult command:

CREATE TABLE IF NOT EXISTS student
(
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50) NOT NULL
);

/* name: InsertStudent :execresult */
INSERT INTO student (name)
VALUES (?);