Snipplr

(SQL) MySQL search - j_junyent

Sun, 13 Jan 2008 19:44:17 GMT

http://sentidoweb.com/2007/07/25/consejos-mysql.php

(SQL) MySQL Commands I wish I could remember - chrisaiv

Sun, 23 Mar 2008 09:45:27 GMT

1. Load Data from a csv file\r\n2. Backing up a complete database\r\n3. Backing up a specific table\r\n4. Backing up multiple databases\r\n5. Restoring a database\r\n6. Setting up foreign keys between two databases

(SQL) Load CSV into MySQL - brentroady

Sat, 12 Aug 2006 11:18:19 GMT

(SQL) Command line instructions to create a database in MySQL - yuconner

Mon, 21 Aug 2006 01:09:40 GMT

$ mysql -u ''adminusername'' -p

(SQL) If Exists Update Else Insert - pauliehaha

Tue, 17 Feb 2009 05:10:31 GMT

(SQL) Update from select - wolfie

Thu, 21 Feb 2008 11:56:51 GMT

(SQL) MySQL Table - ISO Country List with Abbreviations - cbrant

Tue, 10 Jun 2008 01:43:05 GMT

This will create and then populate a MySQL table with a list of the names and ISO 3166 codes for countries in existence.

(SQL) MySQL Mass Text/String Replace - andyhartleeds

Fri, 19 Oct 2007 06:53:12 GMT

(SQL) Migrate MySQL database from old host to a new host - yuconner

Wed, 23 Aug 2006 21:05:40 GMT

(SQL) How to backup mysql database by command line (dump) - yuconner

Tue, 22 Aug 2006 23:09:49 GMT

(SQL) SQL - Find and Replace - jamiebrwr

Fri, 08 Oct 2010 01:41:55 GMT

(SQL) Select Records Less Than 24 Hours Old - traeregan

Fri, 14 Aug 2009 03:15:09 GMT

(SQL) CodeIgniter Session Table SQL - pdswan

Wed, 29 Jul 2009 13:40:23 GMT

(SQL) MySQL Find and Replace Drupal filepaths in files table - shrop

Thu, 17 Jul 2008 14:13:56 GMT

This is useful if you are changing a Drupal site's file upload path and/or changing from a private to a public file store.

(SQL) Importing data from (Excel) CSV into MySQL - jarnaldich

Thu, 26 Jun 2008 02:39:50 GMT

Imports data from CSV (excel-compatible format) into MySQL. Also check the mysqlimport utility and the complementary SELECT ... INTO OUTFILE.

(SQL) MySQL Table - US States - cbrant

Tue, 10 Jun 2008 01:45:05 GMT

This will create and then populate a MySQL table with a list of the names and USPS abbreviations for US states and possessions in existence.

(SQL) Update Select - mafro

Fri, 23 Nov 2007 07:27:28 GMT

Update one table by selecting from another. Avoids cursors.

(SQL) Remove duplicate entries / rows from mySQL - lixonic

Thu, 26 Aug 2010 17:07:29 GMT

This is the quick method and painless way to Remove duplicate entries from MySQL

(SQL) Update one table from another - ChrisCantley

Wed, 11 Aug 2010 00:41:38 GMT

(SQL) IF NOT EXISTS ... INSERT - RealRover

Sat, 07 Aug 2010 02:11:06 GMT

(SQL) Find Stored Procedures with specified name or contains specified text - lance

Thu, 05 Aug 2010 05:31:48 GMT

(SQL) Find string anywhere in Sql Database - emregulcan

Mon, 02 Aug 2010 16:55:37 GMT

(SQL) Timezone database - emregulcan

Fri, 23 Jul 2010 17:43:02 GMT

You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)

(SQL) Calculating distance in Kilometres and Miles from Latitude and Longitude - zingo

Tue, 01 Dec 2009 20:22:06 GMT

Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth.

(SQL) Find Duplicate values in a table column - pauliehaha

Mon, 09 Feb 2009 03:41:14 GMT