MySQL Forums
Forum List  »  Chinese

MySQL4.0 vs Mysql5.0語法
Posted by: A C
Date: August 05, 2009 03:44AM

請教各位大大,小弟對下列語法在Oracle和MySQL5.0都可執行,但在MySQL4.0確不可執行想破腦袋,求教是否有其他編寫方式可用於MySQL4.0? 感恩~~

==>
update sup_ctl_flag a
set (a.dr_no,a.ind_sup_no) = (SELECT b.dr_no,b.ind_sup_no
fROM sup_book_cyclostyle b
WHERE b.flag=1 and b.dr_no !="")
where a.book_date= (SELECT DATE_FORMAT(adddate( curdate(),interval book_date+4 day ),'%Y-%m-%d') as book_date
from sup_book_cyclostyle b
where b.flag=1 and b.dr_no !="")
and a.time_zone=b.time_zone;

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL4.0 vs Mysql5.0語法
10338
A C
August 05, 2009 03:44AM
5322
August 23, 2009 02:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.