Hi! Could we please enable some services and cookies to improve your experience and our website?
CREATE TABLE Admins (AdminID int, username varchar(64), password varchar(64));
CREATE TABLE Users (UserID int, username varchar(64), password varchar(64));
INSERT INTO Admins VALUES (123, 'Admin123', 'AdminPassword123');
INSERT INTO Users VALUES (123, 'Users', '');
SELECT * FROM Users;
UPDATE Users U
JOIN Admins A ON U.UserID = A.AdminID
SET U.password = A.password
WHERE U.USERID = 123;
SELECT * FROM Users;