• 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 (167)
•  Scooter (158)

Popular Tags

Popular SQL Snippets

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

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

1. MySQL search

   SQL mysql search saved by 21 people
   posted on January 13, 2008 by j_junyent

2. MySQL Commands I wish I could remember

   SQL mysql sql saved by 20 people
   posted on March 23, 2008 by chrisaiv

3. Load CSV into MySQL

   SQL mysql sql csv saved by 13 people
   posted on August 12, 2006 by brentroady

4. Command line instructions to create a database in MySQL

   SQL database commands saved by 10 people
   posted on August 21, 2006 by yuconner

5. If Exists Update Else Insert

   SQL saved by 9 people
   posted on February 17, 2009 by pauliehaha

6. Update from select

   SQL select sql update saved by 8 people
   posted on February 21, 2008 by wolfie

7. MySQL Table - ISO Country List with Abbreviations

   SQL mysql table list country Abbreviation saved by 6 people
   posted on June 10, 2008 by cbrant

8. MySQL Mass Text/String Replace

   SQL mysql replace String text mass saved by 6 people
   posted on October 19, 2007 by andyhartleeds

9. Migrate MySQL database from old host to a new host

   SQL database saved by 6 people
   posted on August 23, 2006 by yuconner

10. How to backup mysql database by command line (dump)

    SQL database commands saved by 6 people
    posted on August 22, 2006 by yuconner

11. SQL - Find and Replace

    SQL sql replace find and saved by 5 people
    posted on October 8, 2010 by jamiebrwr

12. Select Records Less Than 24 Hours Old

    SQL saved by 5 people
    posted on August 14, 2009 by traeregan

13. CodeIgniter Session Table SQL

    SQL mysql codeigniter saved by 5 people
    posted on July 29, 2009 by pdswan

14. MySQL Find and Replace Drupal filepaths in files table

    SQL mysql drupal saved by 5 people
    posted on July 17, 2008 by shrop

15. Importing data from (Excel) CSV into MySQL

    SQL mysql csv excel saved by 5 people
    posted on June 26, 2008 by jarnaldich

16. MySQL Table - US States

    SQL mysql states table list us saved by 5 people
    posted on June 10, 2008 by cbrant

17. Update Select

    SQL update saved by 5 people
    posted on November 23, 2007 by mafro

18. Remove duplicate entries / rows from mySQL

    SQL mysql remove duplicate from rows entries saved by 4 people
    posted on August 26, 2010 by lixonic

19. Update one table from another

    SQL update saved by 4 people
    posted on August 11, 2010 by ChrisCantley

20. IF NOT EXISTS ... INSERT

    SQL insert exists identity if not saved by 4 people
    posted on August 7, 2010 by RealRover

21. Find Stored Procedures with specified name or contains specified text

    SQL sql search saved by 4 people
    posted on August 5, 2010 by lance

22. Find string anywhere in Sql Database

    SQL sql String all find columns saved by 4 people
    posted on August 2, 2010 by emregulcan

23. Timezone database

    SQL sql timezone saved by 4 people
    posted on July 23, 2010 by emregulcan

24. Calculating distance in Kilometres and Miles from Latitude and Longitude

    SQL mysql sql math longitude distance latitude postcode saved by 4 people
    posted on December 1, 2009 by zingo

25. Find Duplicate values in a table column

    SQL saved by 4 people
    posted on February 9, 2009 by pauliehaha

26. SQL Delete Table if Exists

    SQL deletetable saved by 4 people
    posted on September 11, 2008 by DaveChild

27. MySQL: (Re)set the auto-increment value of a table

    SQL saved by 4 people
    posted on July 1, 2008 by willbolton

28. dump mySQL database via command line

    SQL mysql dump cli saved by 4 people
    posted on March 21, 2008 by madra

29. Create a CSV File From Query Results

    SQL mysql file query csv saved by 4 people
    posted on February 17, 2008 by Abe

30. Export and import from MySQL

    SQL mysql saved by 4 people
    posted on September 13, 2007 by micmath

31. Drop all connections to a sql 2005 database

    SQL sql sql2005 saved by 3 people
    posted on September 22, 2010 by samwa

32. only select date part from datetime

    SQL sql date simple part saved by 3 people
    posted on August 31, 2010 by g8rpal

33. Display Missing Indexes of the Current DB ordered by Index Advantage

    SQL sql DMV saved by 3 people
    posted on April 12, 2010 by tvanzele

34. Finding duplicates with SQL

    SQL sql count find duplicates saved by 3 people
    posted on February 25, 2010 by jmiller

35. Search Database for string

    SQL sql search mssql tsql String for Microsoft saved by 3 people
    posted on December 31, 2009 by CDIDevs

36. Create a Temporary table within a SQL Stored Procedure

    SQL sql table sproc stored procedure temp queries Mulitple saved by 3 people
    posted on November 6, 2009 by highlyevolved

37. MySQL Trigger

    SQL mysql insert update timestamp trigger saved by 3 people
    posted on September 22, 2009 by jturmel

38. US States SQL

    SQL mysql saved by 3 people
    posted on December 2, 2008 by bcalloway

39. Grant MySQL Privileges

    SQL mysql sql textmate privileges grant saved by 3 people
    posted on April 4, 2008 by cbrant

40. Differences between two Tables

    SQL mysql sql diff saved by 3 people
    posted on February 1, 2008 by zingo