MySQL Snippets

MySQL snippets This is a collection of MySQL tricks/snippets that are really useful for Web developers. If you know any code snippet you may post/share it for others here: Post a Snippet. The most popular of them will be added to this list. We keep adding the new snippets all the time!
Selecting a Random Row Search in Tags Set in MySQL Find and Replace Create Database and Assign User Calculate Relative Time Ago Create CSV from MySQL Insert/Update if Key Already Exists new Random Record Based on Weight new
Post Your Code Snippet
Please be polite and helpful, do not spam or offend others. We promise you will be treated the same way.
Fields marked with * are mandatory
Tips:
Please please put programmimg code in following tags: [php], [sql], [css], [js] etc.

PHP code example: [php] echo date("Y-m-d"); [/php]
Create Your Free Account
Please remember that this information is essential to use our services correctly.
After creating the account you will be able to download all of our FREE products.
Fields marked with * are mandatory






Please send me information about updates, new products, specials and discounts from ApPHP!
We recommend that your password should be at least 6 characters long and should be different from your username/email. Please use only letters of the English alphabet to enter your name.

Your e-mail address must be valid. We use e-mail for communication purposes (order notifications, etc). Therefore, it is essential to provide a valid e-mail address to be able to use our services correctly.

All your private data is confidential. We will never sell, exchange or market it in any way. Please refer to Privacy Policy.

By clicking "Create Account", you are indicating that you have read and agree to the ApPHP Terms & Conditions.

Quick Registration with: Facebook / Google