MariaDB 10.5

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

SELECT version();

version()

10.5.17-MariaDB-1:10.5.17+maria~deb11

CREATE TABLE news (
ID INT PRIMARY KEY,
title VARCHAR(10)
);
INSERT INTO news (ID, title) VALUES (8, 'aaa') RETURNING *;

ID
title

8
aaa

UPDATE news SET title = 'changed' WHERE ID = 8 RETURNING *;

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RETURNING *' at line 1

REPLACE INTO news VALUES (8,'changed') RETURNING *;

ID
title

8
changed

SELECT * FROM news

ID
title

8
changed