Kod:
CREATE TABLE `comp` (
`k_id_COMP` int(11) unsigned NOT NULL auto_increment,
`Name` varchar(255) default NULL,
`BillingAddress` varchar(255) default NULL,
`BillingZip` varchar(10) default NULL,
`BillingCity` varchar(255) default NULL,
`BillingCountry` varchar(255) default NULL,
`VisitAddress` varchar(255) default NULL,
`VisitZip` varchar(10) default NULL,
`VisitCity` varchar(255) default NULL,
`VisitCountry` varchar(255) default NULL
PRIMARY KEY (`k_id_COMP`),
) ENGINE=MyISAM AUTO_INCREMENT=1 COMMENT='Comment'
Tabellen som är auto_increment måste alltid vara Primary Key.