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

• Big /
• Small

login / Register

Share Snipplr

Tools

• Textmate Bundle
• WordPress Plugin
• Snippets

Popular Tags

Everyone's Recent MySQL Snippets

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

1. Remote DB query

   MySQL
   posted 22 hours ago by jtjiver

2. Derive Age of a MySQL tuple in minutes

   MySQL AGE minute
   posted 3 days ago by koguee

3. author_id update

   MySQL
   posted 2 weeks ago by davidbdehaan

4. La fonction COALESCE de MySQL permet de renvoyer une valeur par défaut si la valeur null est renvoyée initialement.

   MySQL mysql
   posted on January 29, 2013 by pruntrut

5. [MySQL] Add condition to Virutal Fields

   MySQL mysql field virtual conditions
   posted on January 10, 2013 by tucq88

6. What MySQL Table Has What Column

   MySQL mysql database sql column
   posted on November 16, 2012 by philsown

7. create new database

   MySQL mysql sql create grant
   posted on October 22, 2012 by claudiodev

8. Remap values inside a MYSQL query using CASE...WHEN syntax

   MySQL mysql select insert update tips
   posted on October 20, 2012 by ginoplusio

9. Delete duplicate records in MySQL database

   MySQL mysqlduplicatedelete
   posted on October 15, 2012 by bluecap

10. Delete duplicate records from MySQL Database

    MySQL delete duplicate
    posted on October 12, 2012 by welancers

11. MySQL - Simulate MySQL Queries

    MySQL mysql database query
    posted on September 20, 2012 by satie83

12. Insert into mysql from csv file

    MySQL mysqlcsv saved by 1 person
    posted on August 26, 2012 by kirkfortune

13. Pivot table Schedule

    MySQL mysql table pivot
    posted on July 25, 2012 by cahyadsn

14. Age in Years for Given Birthdate

    MySQL mysql year AGE birthdate
    posted on July 25, 2012 by cahyadsn

15. Add info to mysql table

    MySQL
    posted on July 14, 2012 by vdubplate

16. Pull from MySQL and display from table

    MySQL
    posted on July 14, 2012 by vdubplate

17. MySQL Time Ago function

    MySQL time relative
    posted on June 16, 2012 by Jamie

18. MySQL Select duplicates

    MySQL mysql select duplicate dup
    posted on June 13, 2012 by TheNullByte

19. mysql create modify default timestamp

    MySQL mysql default timestamp modified created
    posted on May 4, 2012 by navblue

20. Copy an SQL Table

    MySQL mysql copy
    posted on May 2, 2012 by imbraz

21. Users Sharing between multiple Joomla 2.5.x sites

    MySQL mysql joomla
    posted on April 2, 2012 by A973C

22. Replace a text in SQL Server Table Column

    MySQL replace text saved by 1 person
    posted on March 31, 2012 by klovera

23. UPDATE table using JOINS

    MySQL mysql joins
    posted on March 30, 2012 by jgomez

24. Find and Replace MySQL column with substring

    MySQL mysql String functions substring
    posted on March 28, 2012 by jgomez

25. Move specified records from table to table

    MySQL
    posted on February 29, 2012 by kossmoss

26. (Player - Player Agent) Images

    MySQL images player - agent
    posted on February 22, 2012 by karthi

27. Wordpress Display Recent Authors of Posts

    MySQL mysql wordpress
    posted on February 1, 2012 by ninacess

28. Languages table

    MySQL mysql table languages saved by 1 person
    posted on December 8, 2011 by Synnoid

29. Convert textual dates of the form '[d]d-[m]m-yyyy' to actual dates

    MySQL date
    posted on December 6, 2011 by jpkunst

30. MYSQL search and replace

    MySQL mysql
    posted on November 21, 2011 by irishsk

31. MySQL Data Pull to Localhost

    MySQL mysql data mysqldump localhost Pull saved by 1 person
    posted on October 30, 2011 by nedf23

32. Update database fields with search replace word

    MySQL search replace update
    posted on October 26, 2011 by carouselcreative

33. Restore database

    MySQL
    posted on October 24, 2011 by nobsambo

34. 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

35. Average discount in magento 1.4.1

    MySQL mysql magento
    posted on October 20, 2011 by simsevu

36. wordpress - MYSQL - Assign all articles from one author to another

    MySQL mysql database db wordpress wp authors
    posted on October 19, 2011 by krembo99

37. Targa

    MySQL
    posted on October 13, 2011 by zitter

38. MySQL - Commands - ref

    MySQL
    posted on October 12, 2011 by erraja_07

39. Dump mysql database and exclude certain tables

    MySQL
    posted on October 6, 2011 by Tate

40. Change MySQL user password

    MySQL mysql privilege
    posted on October 3, 2011 by athome