Guest User

Untitled

a guest
Apr 26th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. UPDATE coolTable SET columnA = columnB;
  2.  
  3. CREATE TABLE pweb (_id INTEGER PRIMARY KEY,h_id INTEGER ,sent INTEGER);
  4.  
  5. sqlite> select * from pweb;
  6. 1|10|1
  7. 2|20|1
  8. 3|30|0
  9. 4|40|0
  10.  
  11. sqlite> update pweb set h_id = _id;
  12.  
  13. sqlite> select * from pweb;
  14. 1|1|1
  15. 2|2|1
  16. 3|3|0
  17. 4|4|0
Add Comment
Please, Sign In to add comment