3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
请教查找字段
page_table有字段page_id和page_url。
table1中有字段page_url
我要把table1中的page_url转换成page_id插入到table2中,
如何做？一起插入到table2中的还有别的列。
我现在是用
insert into table2 (customer_id,region_id,page_id,time_id)
select c_id,r_id,#####,t_id
from table1
where ()
就是不知道对应page_id的那个#####如何写，请指教，谢谢！
table1中有字段page_url
我要把table1中的page_url转换成page_id插入到table2中,
如何做？一起插入到table2中的还有别的列。
我现在是用
insert into table2 (customer_id,region_id,page_id,time_id)
select c_id,r_id,#####,t_id
from table1
where ()
就是不知道对应page_id的那个#####如何写，请指教，谢谢！
...全文
请发表友善的回复…
发表回复
newline 2003-12-22
谢谢！
zjcxc--个人微信公共号同名 2003-12-16
--当然是join的方法快
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a join page_table b on a.page_url = b.page_url
where ()
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a join page_table b on a.page_url = b.page_url
where ()
newline 2003-12-15
谢谢大家，回答这么快！
我试了马可的两种方法，就是那个意思。
不过不知道数据量很大的时候，这两种和后面的几种方法哪个更优呢？
我试了马可的两种方法，就是那个意思。
不过不知道数据量很大的时候，这两种和后面的几种方法哪个更优呢？
LoveSQL 2003-12-15
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a
join page_table b on a.page_url = b.page_url
where ()
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a
join page_table b on a.page_url = b.page_url
where ()
zjcxc--个人微信公共号同名 2003-12-15
--不知道楼主是否这个意思?
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a join page_table b on a.page_url = b.page_url
where ()
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a join page_table b on a.page_url = b.page_url
where ()
zjcxc--个人微信公共号同名 2003-12-15
楼主的表结构再清晰一点.
table2中有其他列,这些列和要插入的数据是什么关系?
我怎么看像是应该用更新语句来处理啊?
table2中有其他列,这些列和要插入的数据是什么关系?
我怎么看像是应该用更新语句来处理啊?
sunshareforever 2003-12-15
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a inner
join page_table b on a.page_url = b.page_id where ()
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a inner
join page_table b on a.page_url = b.page_id where ()
gmlxf 2003-12-15
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a,page_table b where a.page_url = b.page_url
where ()
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a,page_table b where a.page_url = b.page_url
where ()
sdhdy 2003-12-15
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a,page_table b
where a.page_url=b.page_url
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a,page_table b
where a.page_url=b.page_url
txlicenhe 2003-12-15
或:
insert into table2 (customer_id,region_id,page_id,time_id)
select c_id,r_id,(select page_id from page_table where page_url = table1.page_url ),t_id
from table1
where ()
insert into table2 (customer_id,region_id,page_id,time_id)
select c_id,r_id,(select page_id from page_table where page_url = table1.page_url ),t_id
from table1
where ()
txlicenhe 2003-12-15
insert into table2 (customer_id,region_id,page_id,time_id)
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a
join page_table b on a.page_url = b.page_id
where ()
select a.c_id,a.r_id,b.page_id,a.t_id
from table1 a
join page_table b on a.page_url = b.page_id
where ()