Login / Register

Share Snipplr

Welcome To Snipplr

Everyone's Recent MySQL Snippets Tagged mysql

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 524 posted 11 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 570 posted 11 years ago by TheNullByte

MySQL mysql create modify default timestamp

add created datetime and modified timestamp columns to table

mysql

0 505 posted 12 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 571 posted 12 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 534 posted 12 years ago by A973C

MySQL UPDATE table using JOINS

Update an empty name column in default_comments

mysql

0 490 posted 12 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 802 posted 12 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 682 posted 12 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 1217 posted 12 years ago by Synnoid

MySQL MYSQL search and replace

mysql

0 681 posted 12 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 788 posted 12 years ago by nedf23

MySQL US & CANADA Cities Database

mysql

3 2332 posted 12 years ago by frederichoule

MySQL Average discount in magento 1.4.1

mysql

0 540 posted 12 years ago by simsevu

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

mysql

0 803 posted 12 years ago by krembo99

MySQL Change MySQL user password

mysql

0 651 posted 12 years ago by athome

MySQL Create user & grant privilege

mysql

0 720 posted 12 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 610 posted 12 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 721 posted 12 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 1602 posted 12 years ago by n19ht

MySQL Find string in MYSQL

mysql

0 675 posted 12 years ago by apro2000

MySQL Seleccionar cantidad de comentarios por semanas, Wordpress

mysql

0 581 posted 12 years ago by serialk89

MySQL Find and replace a string

remove the square brackets

mysql

0 677 posted 12 years ago by springy

MySQL MySQL Create User for database

Snippet used to create users on databases

mysql

1 708 posted 12 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.