SQL


April 24, 2006: 12:03 pm: MatthewDebian, Linux Misc, SQL, Technical

Potentially useful?

How To Set Up A Load-Balanced MySQL Cluster | HowtoForge - Linux Howtos and Tutorials

September 9, 2005: 9:24 pm: MatthewSQL, Technical, Tips and Tricks

mysql> SHOW COLUMNS FROM mytable FROM mydb;
mysql> SHOW COLUMNS FROM mydb.mytable;

March 28, 2005: 10:33 pm: MatthewSQL, Technical

I can never remember how to move a database in MS SQL 2000 from one computer to another. Well, now I can quit looking it up and just use the articles.

December 1, 2004: 5:35 pm: MatthewLinux Misc, SQL, Technical

A collection of tech cheat sheets - very useful!

November 23, 2004: 3:58 pm: MatthewSQL

http://dev.mysql.com/doc/mysql/en/ANSI_diff_SELECT_INTO_TABLE.html

Very handy!

: 1:59 pm: MatthewSQL

http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html