sunil gurjar Blog, Asp.net , C# , Ajax, Sql SERVER, Java Script interview Question and answer ,: Mysql error 1093 - Can't specify target table for update in FROM clause

Wednesday, May 07, 2025

Breaking News

>> Securing and encrypt View State and Cookies values >> Page has one or more controls that do not correspond with >> “The Controls collection cannot be modified because the control contains code blocks” >> How to fix "Validation(): Element 'xxxx' is not supported >> How to create a new session in ASP.NET programmatically >> MySQL Database Backup using mysqldump command

Monday, July 2, 2012

Mysql error 1093 - Can't specify target table for update in FROM clause

UPDATE table_name a,

(SELECT

Clonum_name s

FROM table_name

GROUP BY Clonum_name

HAVING COUNT(DISTINCT Cable_no) > 1) b

SET Clonum_name = CONCAT(Clonum_name ,'_',Cable_no)

WHERE a. Clonum_name = b.s

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )