2006-04-29 14:26:50
drop table test1;
drop table test;
create table test(id integer primary key, name varchar(30));
create table test1(id integer, address varchar(30), phone varchar(30), FOREIGN KEY (id) REFERENCES test(id));
insert into test values(1, 'name1');
insert into test1 values(1, 'a', 'a' );
insert into test values(2, 'name2');
insert into test1 values(1, 'b', 'b');
insert into test1 values(2, 'b', 'b');insert into test values(3, 'name3');
insert into test1 values(3, 'c', 'c');
select * from test;
select * from test1;
sunlilei 的BLOG 
博客统计信息
友情链接
背景音乐
51CTO推荐博客
我所关联
文章
热门文章
最新评论
51CTO推荐博文