From: "$B2+9bJv(B"
(B
(B> UPDATE
(B> NGLDENHDT
(B> SET
(B> EDT_HUK_FLG = :EDT_HUK_FLG
(B> WHERE
(B> KAI_CDE = :KAI_CDE
(B> AND EDT_NUM = (SELECT MAX(EDT_NUM)
(B>FROM NGLDENHDT
(B>WHERE KAI_CDE = :KAI_CDE_T1
(B>
$B2+9bJv(B wrote:
(B> i use this mail first .
(B>
(B> i have a problem in under sql program:
(B>
(B>
(B> UPDATE
(B> NGLDENHDT
(B> SET
(B> EDT_HUK_FLG = :EDT_HUK_FLG
(B> WHERE
(B> KAI_CDE = :KAI_CDE
(B> AND EDT_NUM = (SELECT MAX(EDT_NUM)
(B>
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
> W
: Tuesday, April 26, 2005 11:26 PM
(BTo: mysql@lists.mysql.com
(BSubject: update and select question
(B
(B
(Bi use this mail first .
(B
(Bi have a problem in under sql program:
(B
(B
(BUPDATE
(BNGLDENHDT
(BSET
(BEDT_HUK_FLG = :EDT_HUK_FLG
(BWHERE
(B KAI_CDE = :KAI_CDE
(B AND
(Bi use this mail first .
(B
(Bi have a problem in under sql program:
(B
(B
(BUPDATE
(BNGLDENHDT
(BSET
(BEDT_HUK_FLG = :EDT_HUK_FLG
(BWHERE
(B KAI_CDE = :KAI_CDE
(B AND EDT_NUM = (SELECT MAX(EDT_NUM)
(B FROM NGLDENHDT
(B
i use this mail first .
(B
(Bi have a problem in under sql program:
(B
(B
(BUPDATE
(BNGLDENHDT
(BSET
(BEDT_HUK_FLG = :EDT_HUK_FLG
(BWHERE
(B KAI_CDE = :KAI_CDE
(B AND EDT_NUM = (SELECT MAX(EDT_NUM)
(B FROM NGLDENHDT
(B
