MySQL Cookbook: Difference between revisions

From Littledamien Wiki
Jump to navigation Jump to search
(Created page with "==Create table== <syntaxhighlight lang="mysql"> CREATE TABLE IF NOT EXISTS `shipping_rates` ( `id` int(11) NOT NULL auto_increment , `region` varchar(50) default NULL , IND...")
(No difference)

Revision as of 13:18, 25 March 2012

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`)
);