Advertisement
KaeruCT

fix battleplan tactics table [WORK]

Jul 16th, 2012
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. # DELETE ROWS WHERE priority > 26
  2. DELETE FROM tactics WHERE priority > 26;
  3. # CONVERT numbers TO letters
  4. UPDATE tactics SET priority = CHAR((96 + CONVERT(priority, UNSIGNED)) USING ASCII);
  5. # fix ROWS that had 0 IN the FIELD, setting it TO empty
  6. UPDATE tactics SET priority = '' WHERE priority = '`';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement