sqlite - Unsupported Sql

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 4,10 ****
  below.
  
  ----
! *: updating multiple columns with subselect e.g. update T1 set (theUpdatedValue, theOtherValue) = 
  (select theTop, theValue from T2 where T2.theKey = T1.theID)
  
  *: free text search capabilities in select statements:
--- 4,12 ----
  below.
  
  ----
! *: This appears to be unsupported: updating multiple columns with subselect
! 
!    update T1 set (theUpdatedValue, theOtherValue) = 
  (select theTop, theValue from T2 where T2.theKey = T1.theID)
  
  *: free text search capabilities in select statements: