Difference between revisions of "SUPPORT QUERY"
(Created page with "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.h...") |
|||
| Line 57: | Line 57: | ||
UPDATE mypaydv.hst2015 SET hstpccd = '3' | UPDATE mypaydv.hst2015 SET hstpccd = '3' | ||
| + | |||
| + | == '''Reference''' == | ||
| + | [[Media:SUPPORT_QUERY.doc|SUPPORT QUERY document]] | ||
Latest revision as of 12:42, 20 June 2016
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'
