Snipplr - kidmizere http://snipplr.com/users/kidmizere/language/mysql Recent snippets posted on Snipplr.com en-us Sun, 26 May 2013 01:14:42 GMT (MySQL) Add Leading zero to field (ZipCodes) http://snipplr.com/view/56374/add-leading-zero-to-field-zipcodes/

]]> Sun, 10 Jul 2011 14:34:13 GMT http://snipplr.com/view/56374/add-leading-zero-to-field-zipcodes/ (MySQL) timestamp equals today http://snipplr.com/view/55079/timestamp-equals-today/

]]> Thu, 09 Jun 2011 10:40:30 GMT http://snipplr.com/view/55079/timestamp-equals-today/ (MySQL) Append Data to Field in MySql http://snipplr.com/view/51150/append-data-to-field-in-mysql/ Notice the space in the appended portion, otherwise you just tack right on with no separation. If your original value is null you can use this: CONCAT(IFNULL(email_data, ''),' $email_data') This will add it on to a null value as the first value in the entry

]]> Sat, 26 Mar 2011 07:33:33 GMT http://snipplr.com/view/51150/append-data-to-field-in-mysql/ (MySQL) reset auto-increment in mysql http://snipplr.com/view/50017/reset-autoincrement-in-mysql/

]]> Fri, 04 Mar 2011 05:38:01 GMT http://snipplr.com/view/50017/reset-autoincrement-in-mysql/ (MySQL) Adding and testing AES encrypted password field http://snipplr.com/view/45450/adding-and-testing-aes-encrypted-password-field/

]]> Wed, 08 Dec 2010 12:48:40 GMT http://snipplr.com/view/45450/adding-and-testing-aes-encrypted-password-field/