Snipplr

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

Tue, 29 Jan 2013 20:53:55 GMT

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

(MySQL) [MySQL] Add condition to Virutal Fields - tucq88

Thu, 10 Jan 2013 13:50:19 GMT

By using HAVING 'virtual_field' CONDITION we can add conditions to virtual fields that created at SELECT

(MySQL) What MySQL Table Has What Column - philsown

Fri, 16 Nov 2012 00:50:08 GMT

How to find a given column in a given database in MySQL

(MySQL) create new database - claudiodev

Mon, 22 Oct 2012 21:45:32 GMT

Create a new database and its respective user with all privileges

(MySQL) Remap values inside a MYSQL query using CASE...WHEN syntax - ginoplusio

Sat, 20 Oct 2012 08:14:57 GMT

How to remap a value to another inside a mysql query select.

(MySQL) MySQL - Simulate MySQL Queries - satie83

Thu, 20 Sep 2012 20:29:21 GMT

You could start a transaction before running your queries and then rollback after running them. Note that to do this you'll require InnoDB or XtraDb tables (won't work on MyISAM).

(MySQL) Pivot table Schedule - cahyadsn

Wed, 25 Jul 2012 13:43:46 GMT

You have a schedule table (period, day, subject, room) with a primary key period,day to avoid duplicate bookings. You wish to display the schedule as periods, subjects and rooms in rows, and days of the week in columns.

(MySQL) Age in Years for Given Birthdate - cahyadsn

Wed, 25 Jul 2012 13:31:22 GMT

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) MySQL Select duplicates - TheNullByte

Wed, 13 Jun 2012 03:02:48 GMT

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

(MySQL) mysql create modify default timestamp - navblue

Fri, 04 May 2012 04:34:27 GMT

add created datetime and modified timestamp columns to table

(MySQL) Copy an SQL Table - imbraz

Wed, 02 May 2012 22:41:45 GMT

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

(MySQL) Users Sharing between multiple Joomla 2.5.x sites - A973C

Mon, 02 Apr 2012 13:49:54 GMT

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

(MySQL) UPDATE table using JOINS - jgomez

Fri, 30 Mar 2012 00:47:33 GMT

Update an empty name column in default_comments

(MySQL) Find and Replace MySQL column with substring - jgomez

Wed, 28 Mar 2012 22:00:49 GMT

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) Wordpress Display Recent Authors of Posts - ninacess

Wed, 01 Feb 2012 09:55:39 GMT

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) Languages table - Synnoid

Thu, 08 Dec 2011 20:38:40 GMT

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

(MySQL) MYSQL search and replace - irishsk

Mon, 21 Nov 2011 03:14:28 GMT

(MySQL) MySQL Data Pull to Localhost - nedf23

Sun, 30 Oct 2011 17:19:22 GMT

What it does 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 and the part after the "|" is where it is going to. In this case, it's localhost. How to use it Run from command prompt or terminal. Replace brackets with values.

(MySQL) US & CANADA Cities Database - frederichoule

Sat, 22 Oct 2011 12:36:31 GMT

(MySQL) Average discount in magento 1.4.1 - simsevu

Thu, 20 Oct 2011 19:20:56 GMT