update

Wed, 02 Aug 2006 13:41:30 -0700 

FB2.0RC3

åÓÔØ ÐÒÏÃÅÄÕÒÁ:

  update notices set state=3
  where id_notice in
(     SELECT n.ID_NOTICE
      from notices n, styles s, categories c left join blocks b on 
c.id_block=b.id_block
                                             left join titles t on 
c.id_title=t.id_title
                                             left join subtitles st on 
c.id_subtitle=st.id_subtitle
      where n.id_style = s.id_style
        and n.id_category = c.id_category
        and n.state = 2
        and (n.date_notice between '26.07.2006' and '02.08.2006')
 )

× ×ÙÂÏÒËÅ ËÏÔÏÒÏÊ ×ÓÅÇÏ 159 ÚÁÐÉÓÅÊ, ÎÏ ÏÔÒÁÂÁÔÙ×ÁÅÔ ÂÏÌÅÅ 6 ÍÉÎÕÔ. ðÒÉ ÜÔÏÍ 
ÅÓÌÉ ÓÄÅÌÁÔØ ×ÙÛÅÕËÁÚÁÎÎÙÊ select ÏÔÄÅÌØÎÏ, ÔÏ ×ÙÐÏÌÎÅÎÉÅ 2-3 ÓÅËÕÎÄÙ.
åÓÌÉ ÐÅÒÅÐÉÓÁÔØ ×ÏÔ ÔÁË:

  update notices set state=3
  where id_notice in
(     SELECT n.ID_NOTICE
      from notices n
      where n.state = 2
        and (n.date_notice between '26.07.2006' and '02.08.2006')
 )

ÔÏ ÏÔÒÁÂÁÔÙ×ÁÅÔ ÔÏÖÅ 2-3 ÓÅËÕÎÄÙ. þÅÍ ÓÅÒ×ÅÒÕ ÎÅ ÎÒÁ×ÉÔØÓÑ ÐÅÒ×ÙÊ ÚÁÐÒÏÓ?

Ответить