CREATE TABLE phones ( id int(10) unsigned NOT NULL auto_increment, person_id int(10) unsigned NOT NULL default '0', phone varchar(15) NOT NULL default '', PRIMARY KEY (id), KEY people_id (person_id), KEY phone (phone) ) TYPE=MyISAM AUTO_INCREMENT=3 ; INSERT INTO phones VALUES (1, 1, '1234567890'); INSERT INTO phones VALUES (2, 1, '1122334455');