Snipplr

(SQL) MySQL: (Re)set the auto-increment value of a table - willbolton

Tue, 01 Jul 2008 20:03:35 GMT

(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) 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) Multiple inserts - indianocean

Thu, 29 May 2008 09:50:41 GMT

(SQL) Trac Report Alle offenen Aufgaben - qrist0ph

Thu, 22 May 2008 04:18:22 GMT

(SQL) Comma-Delimited List using Coalesce - mcbutterbuns

Tue, 20 May 2008 17:50:43 GMT

If you ever need to build a comma delimited list out of a column in SQL you can easily do this using the COALESCE function.

(SQL) Simple Oracle Trigger - indianocean

Mon, 05 May 2008 11:00:42 GMT

(SQL) MySQL random password string - stancell

Mon, 21 Apr 2008 12:38:10 GMT

(SQL) proba - grogi

Thu, 17 Apr 2008 18:44:56 GMT

Stored procedure for adding new person.

(SQL) Storing an IP address in a database table - zingo

Wed, 09 Apr 2008 20:31:52 GMT

You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP stack implementation or even application. The INET_ATON() function converts Internet addresses from the numbers-and-dots notation into a 32-bit unsigned integer, and INET_NTOA() does the opposite.

(SQL) MySQL Zip Code Table Structure - tclancy

Wed, 09 Apr 2008 07:51:55 GMT

(SQL) Check MySQL Queries - Leech

Fri, 04 Apr 2008 22:41:02 GMT

(SQL) Grant MySQL Privileges - cbrant

Fri, 04 Apr 2008 03:52:39 GMT

To grant all privileges to a user from any location login to the mysql shell and run the following queries.

(SQL) Set MySQL root password - cbrant

Fri, 04 Apr 2008 03:48:37 GMT

To reset the MySQL root password, login to the mysql shell and run the following commands.

(SQL) MySQL Unix Timestamps - mafro

Tue, 01 Apr 2008 10:00:15 GMT

Example of date parsing when you store a unix timestamp as an int in your DB.

(SQL) UPDATE, falls Eintrag schon vorhanden, sonst INSERT - drk

Sun, 30 Mar 2008 10:20:13 GMT

Wenn ein INSERT einen doppelten Wert erzeugen würde, wird das UPDATE ausgeführt.

(SQL) Simple Oracle stored procedure - indianocean

Wed, 26 Mar 2008 06:51:42 GMT

Just a template...

(SQL) TSQL for Recursive Select Using Common Table Expressions - rengber

Mon, 24 Mar 2008 18:00:18 GMT

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

Sun, 23 Mar 2008 09:45:27 GMT

1. Load Data from a csv file 2. Backing up a complete database 3. Backing up a specific table 4. Backing up multiple databases 5. Restoring a database 6. Setting up foreign keys between two databases