Code Colorizing MySQL

September 25, 2008 at 7:15 am · Filed under CompuScriptology, Technology

An example of code colorizing MySQL table creation.
This example shows creation of a simple contact list, or client list.

1
2
3
4
5
6
7
8
9

CREATE TABLE IF NOT EXISTS `clients` (
 `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
 `email_address` VARCHAR(72) character SET ASCII NOT NULL,
 `firstname` VARCHAR(16) character SET utf8 NOT NULL,
 `lastname` VARCHAR(20) character SET utf8 NOT NULL,
 `date_added` DATETIME NOT NULL,
 UNIQUE KEY `id` (`id`),
 UNIQUE KEY `email_address` (`email_address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

What’s up with IS?

I guess IN and IS are considered key words in MySQL and the Geshi Generic Syntax Highlighter colorizing library. Is that a bug in the parsing routine, or what?

Tags: , , ,

Comments

Instant Rails 1.7

April 10, 2007 at 4:27 am · Filed under Methodology, Webdesignology

One of the quickest ways to get started with Ruby on Rails is with Instant Rails. Instant RoR version 1.7 is now available (see v1.7 release notes).

The first package I tried was v1.3, and I was impressed with how easy it was to download, unzip, and get Ruby, PHP, mySQL, and Apache up and running. In addition to the great new Ruby tools, you get PHP, mySQL, and phpMyAdmin in the install package, because that is the quickest way to configure an OpenSource management tool for your mySQL databases.

Includes Mongrel 1.0.1 support.

Very cool. Highly recommended.

Tags: , , , , , , , ,

Comments