RE: Business Key Generation

2010-02-05 Thread Gavin Towey
, February 05, 2010 9:37 AM To: mysql@lists.mysql.com Subject: Business Key Generation Hi, I have a table that I need to migrate some data into: CREATE TABLE `employee` ( `employeeid` bigint(20) NOT NULL auto_increment, .. `reference` varchar(20) default NULL, `fkcompanyid` bigint(20) default

Business Key Generation

2010-02-05 Thread Tom Goring
Hi, I have a table that I need to migrate some data into: CREATE TABLE `employee` ( `employeeid` bigint(20) NOT NULL auto_increment, .. `reference` varchar(20) default NULL, `fkcompanyid` bigint(20) default NULL, PRIMARY KEY (`employeeid`), KEY `FK4722E6AE82D7E095` (`fkcompanyid`), CONS