Astrolitterbox

Monday, May 28, 2012

Set values to null in SQLite; table updating

Lest I forget:

UPDATE Table SET z = z/300000 where abs(z) > 2


Posted by astrolitterbox at 8:56 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: databases, SQLite

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2014 (3)
    • ►  March (1)
    • ►  January (2)
  • ►  2013 (117)
    • ►  December (6)
    • ►  November (23)
    • ►  October (3)
    • ►  September (3)
    • ►  August (2)
    • ►  June (12)
    • ►  May (14)
    • ►  April (12)
    • ►  March (3)
    • ►  February (14)
    • ►  January (25)
  • ▼  2012 (96)
    • ►  December (8)
    • ►  November (12)
    • ►  October (19)
    • ►  September (5)
    • ►  August (25)
    • ▼  May (8)
      • Set values to null in SQLite; table updating
      • Left outer joins with SQLITE
      • SDSS axis ratio measures
      • Including source code in LaTeX document
      • Counting occurences of a particular word in a file
      • NED batch job form
      • HyperLeda sql field names
      • Left outer joins in SDSS
    • ►  April (13)
    • ►  March (5)
    • ►  February (1)

About Me

astrolitterbox
I am an astrophysics PhD student. My memory is short, hence this blog.
View my complete profile
Awesome Inc. theme. Powered by Blogger.