6 lines
160 B
MySQL
6 lines
160 B
MySQL
|
CREATE PROCEDURE UpdateUserName @OldName varchar(255), @NewName varchar(255)
|
||
|
|
AS
|
||
|
|
UPDATE Users
|
||
|
|
SET UserName = @NewName, LikeCount = 0
|
||
|
|
WHERE UserName = @OldName
|
||
|
|
GO
|