uberdragon on 02/27/11
Last Edited at 02/27/11 04:26am
ALTER TABLE `table` CHANGE `zip` `zip` CHAR(5); #changes typeUPDATE table SET `zip`=LPAD(`zip`, 5, '0'); #pads everything
Report this snippet Tweet
Comment:
You need to login to post a comment.