INSERT INTO A( a,b) SELECT a,b FROM B; 将表B中的a,b复制到表A中的a和b中
SELECT * INTO A FROM B
update A set ip = (SELECT 'XXXX'||':'||substring(ip,'....$') FROM A as b where id = A.id) where ip like '%XXXXX%' 将表A中的某列的值(字符串类型)进行拼接和筛选
INSERT INTO A( a,b) SELECT a,b FROM B; 将表B中的a,b复制到表A中的a和b中
SELECT * INTO A FROM B
update A set ip = (SELECT 'XXXX'||':'||substring(ip,'....$') FROM A as b where id = A.id) where ip like '%XXXXX%' 将表A中的某列的值(字符串类型)进行拼接和筛选