创建表
create table people ( id int ,name varchar(50) ) create table toys ( id int ,name varchar(50) ,people_id int )
向表中插入数据
insert into people(id,name) values(1,‘chucklu‘) insert into people(id,name) values(2,‘lihu‘)
insert into toys(id,name,people_id) values(1,‘a‘,1) insert into toys(id,name,people_id) values(1,‘b‘,2) insert into toys(id,name,people_id) values(1,‘c‘,1) insert into toys(id,name,people_id) values(1,‘d‘,2) insert into toys(id,name,people_id) values(1,‘e‘,1)
原文：http://www.cnblogs.com/chucklu/p/5992261.html