• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Top Users

•  chrisaiv (285)
•  jerryvig (264)
•  girliegeek (213)
•  scott2b (208)
•  noah (207)
•  narkisr (188)
•  ljayz (185)
•  adrianparr (180)
•  1man (166)
•  Scooter (158)

Popular Tags

Popular MySQL Snippets Tagged 'mysql'

• All time
•  / week
•  / month
•  / year

• All / 
• JavaScript / 
• HTML / 
• PHP / 
• CSS / 
• Ruby / 
• Objective C

1. MySQL Find and Replace

   MySQL mysql path replace find saved by 10 people
   posted on February 25, 2010 by Jamie

2. Create CSV from MySQL

   MySQL mysql saved by 6 people
   posted on September 17, 2010 by matula

3. Find duplicate records

   MySQL mysql deduplication saved by 6 people
   posted on May 5, 2010 by fugue

4. Correcting wrong character encoding in MySQL data

   MySQL mysql character utf8 convert encoding latin1 saved by 6 people
   posted on March 6, 2009 by jdbartlett

5. Load CSV back into mySQL

   MySQL mysql saved by 5 people
   posted on September 17, 2010 by matula

6. Drupal 6.x Find PHP code in database

   MySQL mysql php drupal saved by 5 people
   posted on December 4, 2009 by ReeceMarsland

7. Generate random string in MySQL

   MySQL login mysql random saved by 5 people
   posted on November 10, 2009 by fugue

8. Select between two dates

   MySQL mysql date between saved by 5 people
   posted on April 26, 2009 by craig1709

9. US & CANADA Cities Database

   MySQL mysql database states sql list usa city United canada cities saved by 4 people
   posted on October 22, 2011 by frederichoule

10. How to Save results from MySQL into an external file

    MySQL mysql saved by 4 people
    posted on December 18, 2009 by endorfin

11. mySQL - database backup commands

    MySQL mysql database db command backup cli saved by 4 people
    posted on June 7, 2009 by stiobhart

12. MySql import

    MySQL mysql saved by 4 people
    posted on April 10, 2009 by glends

13. MySQL Find and Replace

    MySQL mysql saved by 3 people
    posted on March 2, 2011 by nielsenrc

14. How to Back Up and Restore a MySQL Database

    MySQL mysql backup saved by 3 people
    posted on December 15, 2010 by sergeygerasimov

15. Add Wordpress admin user to database

    MySQL mysql wordpress user admin WP3 saved by 3 people
    posted on October 9, 2010 by timkinnane

16. Display MYSQL date as readable to us humans

    MySQL mysql php date saved by 3 people
    posted on September 8, 2010 by flashmac

17. MySQL - Most relevant weighted results based (MATCH AGAINST)

    MySQL mysql sql saved by 3 people
    posted on April 27, 2010 by LuckyShot

18. Find values that occur exactly once in table

    MySQL mysql saved by 3 people
    posted on February 20, 2010 by atma

19. MySQL Age Calucation

    MySQL mysql db saved by 3 people
    posted on December 12, 2009 by mpcircuitry

20. Date formatting with LOAD DATA INFILE

    MySQL mysql data import csv infile saved by 3 people
    posted on December 10, 2009 by j4kp07

21. MySQL REGEX match comma-delimitted list

    MySQL regex mysql csv saved by 3 people
    posted on November 2, 2009 by j4kp07

22. Get random record based on weight

    MySQL mysql random query record weight weighted saved by 3 people
    posted on September 30, 2009 by BFTrick

23. The Worst Performing Indexes

    MySQL mysql performance indexes saved by 3 people
    posted on June 23, 2009 by Eloi

24. Create Table Users

    MySQL mysql performance users vertical partitioning saved by 3 people
    posted on May 5, 2009 by Eloi

25. Create Table Sessions

    MySQL mysql sessions performance ip inetaton inetntoa saved by 3 people
    posted on May 5, 2009 by Eloi

26. How to follow the progress of a running MySQL command

    MySQL mysql saved by 3 people
    posted on February 22, 2009 by paulbooker

27. MySQL Zip Code Table Structure

    MySQL mysql db zipcodes saved by 3 people
    posted on April 9, 2008 by tclancy

28. MySQL Basics

    MySQL basic mysql password secure change installation alter saved by 2 people
    posted on November 14, 2010 by apro2000

29. select duplicate data from mysql table

    MySQL mysql records duplicate saved by 2 people
    posted on November 8, 2010 by kaartz

30. Add 1 to a field (MySQL)

    MySQL mysql add saved by 2 people
    posted on October 16, 2010 by cjmling

31. Swap values for two columns in MySQL table

    MySQL mysql swap saved by 2 people
    posted on October 5, 2010 by fugue

32. Duplicate Entries

    MySQL mysql duplicates saved by 2 people
    posted on September 24, 2010 by Abe

33. MySQL create table syntax

    MySQL mysql saved by 2 people
    posted on July 20, 2010 by dkynyc

34. MySQL batch command

    MySQL mysql saved by 2 people
    posted on July 20, 2010 by dkynyc

35. Select Records older than one week

    MySQL mysql select records older saved by 2 people
    posted on June 24, 2010 by galofre

36. MySQL Administation Snippet

    MySQL mysql administration admin saved by 2 people
    posted on March 21, 2010 by zonetrooperex

37. calculate the difference between dates in one columns within the same table

    MySQL mysql date difference status change Subquery datediff saved by 2 people
    posted on February 19, 2010 by bradless

38. Altering Database Tables: Add More Columns :

    MySQL mysql alter saved by 2 people
    posted on January 15, 2010 by magicrebirth

39. MySQL Canada Provinces Territories

    MySQL mysql insert table list create canada Provinces Territories saved by 2 people
    posted on August 1, 2009 by CuDDL

40. Nearest Place

    MySQL mysql longitude latitude place nearest saved by 2 people
    posted on April 20, 2009 by martyncoup