Hi, Look at select ... for update here : http://dev.mysql.com/doc/mysql/en/innodb-locking-reads.html
Mathias Selon "$B2 9bJv(B" <[EMAIL PROTECTED]>: > > i use this mail first . > > i have a problem in under sql program: > > > UPDATE > NGLDENHDT > SET > EDT_HUK_FLG = :EDT_HUK_FLG > WHERE > KAI_CDE = :KAI_CDE > AND EDT_NUM = (SELECT MAX(EDT_NUM) > FROM NGLDENHDT > WHERE KAI_CDE = :KAI_CDE_T1 > AND EDT_NUM != '9999'); > > the error message was: > > You can't specify target table 'NGLDENHDT' for update in FROM > clause > > > what can i do ,help me ? > > > thank you very much!! > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
