Results 1 to 3 of 3
Nov 24, 2012, 10:20 #1
[MySQL 5.0.45-community-nt-log] [Err] 1093 - You can't specify target table...
I am currently getting the error
[Err] 1093 - You can't specify target table 'tbl_login' for update in FROM clause
Any help would be much appreciated!
Many thanks in advance for your time.
UPDATE tbl_login SET login1 = ( SELECT SUBSTRING_INDEX(EMAIL, '@', 1) AS login1 FROM tbl_login ) WHERE 1 AND ISNULL(login1);Thanks you very much for your help
I'm really happy for your quickly answer.