Vos Virtual Network

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.

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: Geshi, mySQL, SQL, syntax