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