MySQL 8.0

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

create table TB_User (
    Username varchar(512),
    Password varchar(512),
    Email varchar(512),
    DateCreated datetime)
create unique index unq_tb_user_username on TB_User(username)
CREATE PROCEDURE SP_AddUpdateUser
(
    IN InputUsername VARCHAR(512),
    IN InputPassword VARCHAR(512),
    IN InputEmail VARCHAR(512)
)
BEGIN
    INSERT INTO TB_User(Username, Password, Email, DateCreated)
        SELECT InputUsername, InputPassword, InputEmail, Now()
        ON DUPLICATE KEY UPDATE Password = InputPassword, Email = InputEmail;
END;
CALL SP_AddUpdateUser ('a', 'b', 'c');
SELECT * from TB_User


Username
Password
Email
DateCreated


a
b
c
2022-09-11 07:25:26


CALL SP_AddUpdateUser ('a', 'd', 'e');
SELECT * from TB_User


Username
Password
Email
DateCreated


a
d
e
2022-09-11 07:25:26