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 | |
|---|---|---|
| 173 | Иван | test@test.com |