update lbmoverseascountry a inner join lbmcodeitems b on a.CountryName like CONCAT(b.name,'%')
set CountryCode=b.`Code` where b.setid='A019' and Length(a.CountryCode)>=6
select a.CountryName,b....
UPDATE new_schedules_spider_static_schedule s
join new_scac_port p on p.`PORT` = s.`PORT` and p.SCAC = 'aaa'
set s.PORT_CODE = p.BASIC_CODE
WHERE s.SCAC = 'aaa'
一.构造相关表P1,P2
create table p1(id int,name char(10));
create table p2(id int,name char(10));
二.批量插入数据
begin
for i in 1 .. 100000
loop
insert into p1 values(i,'a'||i);
end loop
;
co...
update ord a
inner join room b on a.roomno=b.roomno
inner join flat c on a.flatno = c.flatno and a.flatsub=c.flatsub
set a.xrea = b.xrea,
a.ritysubn=b.ritysubn,
a.blockno=b.blockno,
a.blockn=b.blockn,...
create table test1 as select * from dba_objects;
create table test2 as select * from dba_objects;
create unique index test1_idx1 on test1(object_id);
select * from test1;
create table test3 a...