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

18 lines
239 B
SQL

DELIMITER $$
CREATE PROCEDURE `User_UpdatePasswordById`
(
in_id VARCHAR(36),
in_password VARCHAR(200)
)
BEGIN
UPDATE
`Users`
SET
`password` = in_password
WHERE
`id` = in_id;
END$$