Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

mysql sql drupal wordpress database mac osx convert textmate date command backup ip url replace find user list line table log update query data regex csv php terminal order email path search security unix mail magento Bash linux cache code copy regexp filter forms text joomla cakephp server customer class windows format web iphone ajax api xml android actionscript window animation magentoextension apache Business service

Welcome To Snipplr

Everyone's Recent MySQL Snippets Tagged mysql

« Prev 1 2 3 4 5 6 Next »

MySQL Age in Years for Given Birthdate

Given a birthdate in @dob, here are two simple formulae for age in years : (the second formulae is for age in years to two decimal places, ignoring day of month)

mysql

0 1513 posted 14 years ago by cahyadsn

MySQL MySQL Select duplicates

Instead of the standard return of duplicates, this will actually show the rows that are duplicated, making it easier to see the data

mysql

0 1792 posted 14 years ago by TheNullByte

MySQL mysql create modify default timestamp

add created datetime and modified timestamp columns to table

mysql

0 1529 posted 14 years ago by navblue

MySQL Copy an SQL Table

Create a new table from the details of another table then insert the table contents

mysql

0 1657 posted 14 years ago by imbraz

MySQL Users Sharing between multiple Joomla 2.5.x sites

xxxx1... are tables from master site xxxx2... are tables from client site

mysql

0 1563 posted 14 years ago by A973C

MySQL UPDATE table using JOINS

Update an empty name column in default_comments

mysql

0 1556 posted 14 years ago by jgomez

MySQL Find and Replace MySQL column with substring

Example: There is a table, 'user', with a column, 'clear', containing values such as: `clear -------- \'animal\' \'pass'\ ` and we would like to retrieve 'animal' and 'pass' ( without the pre & post \' )

mysql

0 2255 posted 14 years ago by jgomez

MySQL Wordpress Display Recent Authors of Posts

Select wp_users and wp_posts to retrieve data from both tables in order to display post title, post date, author name with gravatar (gravatar isn't listed in this code) Note: probably not idea solution, but it's one of many fixes

mysql

0 1815 posted 14 years ago by ninacess

MySQL Languages table

Most popular languages on the web table (in order of popularity). Handy for auto complete fields and such.

mysql

0 3417 posted 14 years ago by Synnoid

MySQL MYSQL search and replace

mysql

0 1875 posted 14 years ago by irishsk

MySQL MySQL Data Pull to Localhost

<h1>What it does</h1> <p>This snippet is used to pull data from one server to another. I primarily use it to get the latest data from our production to our development environments. The first part of the command is where the data is pulling from a...

mysql

1 3209 posted 14 years ago by nedf23

MySQL US & CANADA Cities Database

mysql

3 5249 posted 14 years ago by frederichoule

MySQL Average discount in magento 1.4.1

mysql

0 1910 posted 14 years ago by simsevu

MySQL wordpress - MYSQL - Assign all articles from one author to another

mysql

0 2169 posted 14 years ago by krembo99

MySQL Change MySQL user password

mysql

0 1801 posted 14 years ago by athome

MySQL Create user & grant privilege

mysql

0 1931 posted 14 years ago by athome

MySQL CMS Made Simple Query for Pages Containing \'#\'

Get all page names and ids from the DB of pages with content containing '#'

mysql

0 1759 posted 15 years ago by nielsenrc

MySQL Save a MySQL Query as a Tab or Comma separated file

Simple example of how you can output a query as

mysql

0 1907 posted 15 years ago by Jamie

MySQL Convertir datos de latin1 a utf8 en MySQL

Con estas instrucciones se pueden corregir los caracteres latinos que hayan sido almacenados errÃ³neamente en una base de datos MySQL

mysql

1 3110 posted 15 years ago by n19ht

MySQL Find string in MYSQL

mysql

0 2128 posted 15 years ago by apro2000

MySQL Seleccionar cantidad de comentarios por semanas, Wordpress

mysql

0 1685 posted 15 years ago by serialk89

MySQL Find and replace a string

remove the square brackets

mysql

0 1950 posted 15 years ago by springy

MySQL MySQL Create User for database

Snippet used to create users on databases

mysql

1 1973 posted 15 years ago by digitalclubb

MySQL SELECCIONAR LOS REGISTROS MAS REPETIDOS

Seleccion los datos mas repetidos de una tabla y los ordeno por la cantidad que se repiten, sirve para seleccionar a los usuarios mÃ¡s activos por ejemplo, etc.