SQL 如下:
(1)
drop table user_orders;
create table user_orders (?????????
??????? user_id int8 references userinfos(user_id),
??????? order_id int8 references orders(order_id)
);
(2)
drop table user_orders;
create table? user_orders (
??????? user_id int8,
??????? order_id int8,
??????? foreign key (user_id) references userinfos(user_id),
??????? foreign key (order_id) references orders(order_id)
);
??????????
殊途同歸。
|----------------------------------------------------------------------------------------|
版權聲明 版權所有 @zhyiwww
引用請注明來源 http://www.tkk7.com/zhyiwww
|----------------------------------------------------------------------------------------|
posted on 2009-05-15 11:47
zhyiwww 閱讀(317)
評論(0) 編輯 收藏 所屬分類:
database 、
linux 、
Postgres