MySQL Cookbook

Create table

CREATE TABLE IF NOT EXISTS `shipping_rates` (
	`id` int(11) NOT NULL auto_increment
	, `region` varchar(50) default NULL
	, INDEX `IX_shipping_rates_region` (`region` ASC) 
	, PRIMARY KEY  (`id`)
);

See also

• MySQL Full-Text Search