Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> insert into SysUserDB.User (UserName, CreatedOn, CreatedBy) values ('ROOT', 1406107488484, (select SysUserDB.User.idUser from SysUserDB.User where SysUserDB.User.UserName = 'SYSTEM'));
ERROR 1093 (HY000): You can't specify target table 'User' for update in FROM clause
mysql> describe SysUserDB.User;
+---------------------+--------------+------+-----+---------+----------------+
| Field               | Type         | Null | Key | Default | Extra          |
+---------------------+--------------+------+-----+---------+----------------+
| idUser              | int(11)      | NO   | PRI | NULL    | auto_increment |
| UserName            | varchar(255) | NO   | UNI | NULL    |                |
| Name                | varchar(255) | YES  |     | NULL    |                |
| Password            | varchar(255) | YES  |     | NULL    |                |
| ContactNumber1      | varchar(255) | YES  |     | NULL    |                |
| ContactNumber2      | varchar(255) | YES  |     | NULL    |                |
| EmailAddress        | varchar(255) | YES  |     | NULL    |                |
| Department          | varchar(255) | YES  |     | NULL    |                |
| Status              | varchar(255) | YES  |     | NULL    |                |
| LastLoggedInAt      | bigint(20)   | YES  |     | NULL    |                |
| FailedLoginAttempts | int(11)      | YES  |     | NULL    |                |
| CreatedOn           | bigint(20)   | NO   |     | NULL    |                |
| CreatedBy           | int(11)      | NO   | MUL | NULL    |                |
| ModifiedOn          | bigint(20)   | YES  |     | NULL    |                |
| ModifiedBy          | int(11)      | YES  | MUL | NULL    |                |
| ApprovedOn          | bigint(20)   | YES  |     | NULL    |                |
| ApprovedBy          | int(11)      | YES  | MUL | NULL    |                |
| MakerNCheckerStatus | varchar(255) | YES  |     | NULL    |                |
+---------------------+--------------+------+-----+---------+----------------+
18 rows in set (0.00 sec)