MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  email VARCHAR(255)
) AUTO_INCREMENT = 173;
INSERT INTO users (name, email) VALUES ('Иван', 'test@test.com');
SELECT LAST_INSERT_ID() INTO @id;
SELECT @id;


@id


173


PREPARE stmt FROM 'SELECT * FROM users WHERE id = ? LIMIT 1';
EXECUTE stmt USING @id;
DROP PREPARE stmt;

Statement prepared




id
name
email


173
Иван
test@test.com