您创建一个单独的电话号码表（即1：M关系）。
create table `users` ( `id` int unsigned not null auto_increment, `name` varchar(100) not null, primary key(`id`));create table `phone_numbers` ( `id` int unsigned not null auto_increment, `user_id` int unsigned not null, `phone_number` varchar(25) not null, index pn_user_index(`user_id`), foreign key (`user_id`) references users(`id`) on delete cascade, primary key(`id`));
现在，您可以通过简单的连接轻松获得用户的电话号码；
select pn.`phone_number`from `users` as u, `phone_numbers` as pnwhere u.`name`='John' and pn.`user_id`=u.`id`
