Posts Tagged ‘SQL’

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?

  • How To Find Ruby User Groups March 9, 2010
    Ruby User Groups (RUGs, for short) are typically informal organizations put together to encourage Ruby developers with certain areas to get together, share ideas, and, often, to have some fun. If you're lacking for inspiration or want to get to know some Rubyists within certain parts of the world (or just around the corner, if you're lucky), headin […]
  • Vagrant: EC2-Like Virtual Machine Building and Provisioning from Ruby March 8, 2010
    Vagrant is a Ruby-based tool for building and deploying virtualized development environments. It uses Oracle's open-source VirtualBox virtualization system along with the Chef configuration management engine along with lots of Ruby goodness to automate the creation and provisioning of virtual machines for development purposes. […]