Clarkson/flyway/sql/V1.3__Create_Procedure_User_UpdateById.sql
2018-02-10 17:53:54 +00:00

20 lines
292 B
SQL

DELIMITER $$
CREATE PROCEDURE `User_UpdateById`
(
in_id VARCHAR(36),
in_email VARCHAR(100),
in_username VARCHAR(100)
)
BEGIN
UPDATE
`Users`
SET
`email` = in_email,
`username` = in_username
WHERE
`id` = in_id;
END$$