View source for SUPPORT QUERY

13 mo misc VIP.txt

SELECT * FROM mypaydb.hst2015

SELECT * FROM mypaydv.hst2015


SELECT * FROM mypaydv.hst2015 WHERE HSTNUMB IN(
SELECT HSTNUMB FROM mypaydb.hst2015
)


oa.hst2015_vip_b413mocomp

CREATE TABLE IF NOT EXISTS oa.hst2015_vip_b413mocomp_20151204 LIKE mypaydv.hst2015;
INSERT INTO oa.hst2015_vip_b413mocomp_20151204 SELECT * FROM mypaydv.hst2015;


INSERT IGNORE INTO mypaydv.hst2015
SELECT * FROM mypaydb.hst2015 WHERE hstnumb IN(
SELECT HSTNUMB FROM mypaydv.hst2015
)


DELETE FROM mypaydb.hst2015 WHERE hstnumb IN(
SELECT HSTNUMB FROM mypaydv.hst2015
)

UPDATE mypaydv.hst2015  SET hstpccd = '3'


SELECT * FROM mypaydb.hst2015

SELECT * FROM mypaydv.hst2015


SELECT * FROM mypaydv.hst2015 WHERE HSTNUMB IN(
SELECT HSTNUMB FROM mypaydb.hst2015
)


oa.hst2015_vip_b413mocomp

CREATE TABLE IF NOT EXISTS oa.hst2015_vip_b413mocomp_20151204 LIKE mypaydv.hst2015;
INSERT INTO oa.hst2015_vip_b413mocomp_20151204 SELECT * FROM mypaydv.hst2015;


INSERT IGNORE INTO mypaydv.hst2015
SELECT * FROM mypaydb.hst2015 WHERE hstnumb IN(
SELECT HSTNUMB FROM mypaydv.hst2015
)


DELETE FROM mypaydb.hst2015 WHERE hstnumb IN(
SELECT HSTNUMB FROM mypaydv.hst2015
)

UPDATE mypaydv.hst2015  SET hstpccd = '3'

== '''Reference''' ==
[[Media:SUPPORT_QUERY.doc|SUPPORT QUERY document]]