Skip to content

Instantly share code, notes, and snippets.

@alexzhan

alexzhan/mysql update table where something not null

Created January 21, 2011 05:44
Show Gist options
  • Save alexzhan/789288 to your computer and use it in GitHub Desktop.
Save alexzhan/789288 to your computer and use it in GitHub Desktop.
Download ZIP
mysql update table where something not null
Raw
mysql update table where something not null
Being Processed Before:
http://goo.gl/JfLwg
1. update T_Image set isFetched=1 where url<>''
2. update T_Image set isFetched=1 where dir<>''
Being Processed After:
http://goo.gl/ooxfj
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment