sqlite - Unsupported Sql

Not logged in

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

• Contents
• No-Diff
• Text

*** 15,20 ****
--- 15,25 ----
        UPDATE table SET col = 'value', col2 = 'value2'
        WHERE id_r = 'id_of_row' LIMIT 1;
  
+ _: You can use something like this instead for LIMIT 1:
+ 
+       SELECT ROWID FROM table WHERE id_r = 'id_of_row' LIMIT 1;
+       UPDATE table SET col = ... WHERE ROWID = ...;
+ 
  *: 2006.04.28 : DROP CONSTRAINT statement:
  
        ALTER TABLE myTable DROP CONSTRAINT defPK