鐢?/p>
sql
璇彞锛屽垹闄ゆ帀閲嶅椤瑰彧淇濈暀涓�鏉?/p>
鍦ㄥ嚑鍗冩潯璁板綍閲岋紝瀛樺湪鐫�浜涚浉鍚岀殑璁板綍锛屽浣曡兘鐢?/p>
sql
璇彞锛屽垹闄ゆ帀閲嶅鐨勫憿
1
銆佹煡鎵捐〃涓浣欑殑閲嶅璁板綍锛岄噸澶嶈褰曟槸鏍规嵁鍗曚釜瀛楁
(peopleid)
鏉ュ垽鏂?/p>
select * from people
where
peopleid
in
(select
peopleid
from
people
group
by
peopleid
having
count(peopleid)
> 1)
2
銆?/p>
鍒犻櫎琛ㄤ腑澶氫綑鐨勯噸澶嶈褰曪紝
閲嶅璁板綍鏄牴鎹崟涓瓧娈?/p>
(peopleid)
鏉ュ垽鏂紝
鍙暀鏈?/p>
rowid
鏈�灏忕殑璁板綍
delete from people
where
peoplename
in
(select
peoplename
from
people
group
by
peoplename
having
count(peoplename) > 1)
and
peopleid
not
in
(select
min(peopleid)
from
people
group
by
peoplename
having
count(peoplename)>1)
3
銆佹煡鎵捐〃涓浣欑殑閲嶅璁板綍
(
澶氫釜瀛楁
)
select * from vitae a
where
(a.peopleid,a.seq)
in
(select
peopleid,seq
from
vitae
group
by
peopleid,seq
having
count(*) > 1)
4
銆佸垹闄よ〃涓浣欑殑閲嶅璁板綍
(
澶氫釜瀛楁
)
锛屽彧鐣欐湁
rowid
鏈�灏忕殑璁板綍
delete from vitae a
where
(a.peopleid,a.seq)
in
(select
peopleid,seq
from
vitae
group
by
peopleid,seq
having
count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleid,seq having count(*)>1)
5
銆佹煡鎵捐〃涓浣欑殑閲嶅璁板綍
(
澶氫釜瀛楁
)
锛屼笉鍖呭惈
rowid
鏈�灏忕殑璁板綍
select * from vitae a
where
(a.peopleid,a.seq)
in
(select
peopleid,seq
from
vitae
group
by
peopleid,seq
having
count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleid,seq having count(*)>1)
6.
娑堥櫎涓�涓瓧娈电殑宸﹁竟鐨勭涓�浣嶏細
update tablename set [title]=right([title],(len([title])-1)) where title like '
鏉?/p>
%'
7.
娑堥櫎涓�涓瓧娈电殑鍙宠竟鐨勭涓�浣嶏細
update tablename set [title]=left([title],(len([title])-1)) where title like '%
鏉?/p>
'
8.
鍋囧垹闄よ〃涓浣欑殑閲嶅璁板綍
(
澶氫釜瀛楁
)
锛屼笉鍖呭惈
rowid
鏈�灏忕殑璁板綍
update vitae set ispass=-1
where peopleid in (select peopleid from vitae group by peopleid
alter
table
mytable
drop
index
mdl_tag_use_ix;//mdl_tag_use_ix
鏄笂琛ㄦ煡鍑虹殑绱㈠紩鍚嶏紝
key_name
鏇村淇℃伅璇锋煡鐪?/p>
IT
鎶�鏈笓鏍?/p>