How to update the data of one field in the table with one SQL query to another?

Question

MySQL

Hello! It is possible that the question is not well-defined.
In general, a MySQL database and one table: accounts .
Table structure (fields):

name             |   mail                 |   manager
Ivan Ivanov      |   [email protected]   |   Petr Petrov
Sidor Sidorov    |   [email protected]  |   Sergey Sergeev
Petr Petrov      |   [email protected]   |   Sidor Sidorov
...

How to make the record of the manager field updated with the mail value in the link (the manager field with the name field).
Should be in the output:

name             |   mail                 |   manager
Ivan Ivanov      |   [email protected]   |   [email protected]
Sidor Sidorov    |   [email protected]  |   [other value]
Petr Petrov      |   [email protected]   |   [email protected]
...

Thanks everyone for the advice!

Answer 1

Решение такое:

UPDATE accounts AS U1, accounts AS U2 SET U1.manager = U2.mail WHERE U2.name = U1.manager

Answer 2

На MS SQL можно примерно такой скриптик выполнить. на MySql не уверен.

UPDATE accounts 
SET manager = manager.mail
FROM accounts as A
INNER JOIN accounts as manager ON a.manager = manager.name

Answer 3

update
set [manager] = [mail]
with update syntax