Popular SQL Snippets




« Prev [Page 1 of 9] Next »
  1. FAVMySQL search

    SQL mysql search saved by 21 people
    posted on January 13, 2008 by j_junyent
  2. FAVMySQL Commands I wish I could remember

    SQL mysql sql saved by 20 people
    posted on March 23, 2008 by chrisaiv
  3. FAVLoad CSV into MySQL

    SQL mysql sql csv saved by 14 people
    posted on August 12, 2006 by brentroady
  4. FAVCommand line instructions to create a database in MySQL

    SQL database commands saved by 10 people
    posted on August 21, 2006 by yuconner
  5. FAVIf Exists Update Else Insert

    SQL saved by 9 people
    posted on February 17, 2009 by pauliehaha
  6. FAVUpdate from select

    SQL select sql update saved by 8 people
    posted on February 21, 2008 by wolfie
  7. FAVSQL - Find and Replace

    SQL sql replace find and saved by 6 people
    posted on October 8, 2010 by jamiebrwr
  8. FAVMySQL Table - ISO Country List with Abbreviations

    SQL mysql table list country Abbreviation saved by 6 people
    posted on June 10, 2008 by cbrant
  9. FAVMySQL Mass Text/String Replace

    SQL mysql replace String text mass saved by 6 people
    posted on October 19, 2007 by andyhartleeds
  10. FAVMigrate MySQL database from old host to a new host

    SQL database saved by 6 people
    posted on August 23, 2006 by yuconner
  11. FAVHow to backup mysql database by command line (dump)

    SQL database commands saved by 6 people
    posted on August 22, 2006 by yuconner
  12. FAVSelect Records Less Than 24 Hours Old

    SQL saved by 5 people
    posted on August 14, 2009 by traeregan
  13. FAVCodeIgniter Session Table SQL

    SQL mysql codeigniter saved by 5 people
    posted on July 29, 2009 by pdswan
  14. FAVMySQL Find and Replace Drupal filepaths in files table

    SQL mysql drupal saved by 5 people
    posted on July 17, 2008 by shrop
  15. FAVImporting data from (Excel) CSV into MySQL

    SQL mysql csv excel saved by 5 people
    posted on June 26, 2008 by jarnaldich
  16. FAVMySQL Table - US States

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

    SQL update saved by 5 people
    posted on November 23, 2007 by mafro
  18. FAVRemove duplicate entries / rows from mySQL

    SQL mysql remove duplicate from rows entries saved by 4 people
    posted on August 26, 2010 by lixonic
  19. FAVUpdate one table from another

    SQL update saved by 4 people
    posted on August 11, 2010 by ChrisCantley
  20. FAVIF NOT EXISTS ... INSERT

    SQL insert exists identity if not saved by 4 people
    posted on August 7, 2010 by RealRover
  21. FAVFind Stored Procedures with specified name or contains specified text

    SQL sql search saved by 4 people
    posted on August 5, 2010 by lance
  22. FAVFind string anywhere in Sql Database

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

    SQL sql timezone saved by 4 people
    posted on July 23, 2010 by emregulcan
  24. FAVCalculating 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. FAVFind Duplicate values in a table column

    SQL saved by 4 people
    posted on February 9, 2009 by pauliehaha
  26. FAVSQL Delete Table if Exists

    SQL deletetable saved by 4 people
    posted on September 11, 2008 by DaveChild
  27. FAVMySQL: (Re)set the auto-increment value of a table

    SQL saved by 4 people
    posted on July 1, 2008 by willbolton
  28. FAVdump mySQL database via command line

    SQL mysql dump cli saved by 4 people
    posted on March 21, 2008 by madra
  29. FAVCreate a CSV File From Query Results

    SQL mysql file query csv saved by 4 people
    posted on February 17, 2008 by Abe
  30. FAVExport and import from MySQL

    SQL mysql saved by 4 people
    posted on September 13, 2007 by micmath
  31. FAVDrop all connections to a sql 2005 database

    SQL sql sql2005 saved by 3 people
    posted on September 22, 2010 by samwa
  32. FAVonly select date part from datetime

    SQL sql date simple part saved by 3 people
    posted on August 31, 2010 by g8rpal
  33. FAVDelete all dependent rows in all the other tables

    SQL saved by 3 people
    posted on August 4, 2010 by hairajeshk
  34. FAVDisplay Missing Indexes of the Current DB ordered by Index Advantage

    SQL sql DMV saved by 3 people
    posted on April 12, 2010 by tvanzele
  35. FAVFinding duplicates with SQL

    SQL sql count find duplicates saved by 3 people
    posted on February 25, 2010 by jmiller
  36. FAVSearch Database for string

    SQL sql search mssql tsql String for Microsoft saved by 3 people
    posted on December 31, 2009 by CDIDevs
  37. FAVCreate 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
  38. FAVMySQL Trigger

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

    SQL mysql saved by 3 people
    posted on December 2, 2008 by bcalloway
  40. FAVSQL Run Sanity Checks SP

    SQL sanitychecks saved by 3 people
    posted on September 11, 2008 by DaveChild
« Prev [Page 1 of 9] Next »