Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT t1.* FROM testing.transactions AS t1 LEFT OUTER JOIN fsrp.transactions AS t2 USING(trans_id) WHERE t2.trans_id IS NULL;
- +----------+----------+-------------+------+---------+---------------+--------+-------------------+---------------------+---------------------+---------------------+
- | trans_id | username | transaction | type | periods | periods_bonus | amount | account | timestamp | coverage_start | coverage_end |
- +----------+----------+-------------+------+---------+---------------+--------+-------------------+---------------------+---------------------+---------------------+
- | 1198928 | reliance | 0 | CRDT | 100 | 0 | 0.00 | NULL | 2019-01-17 20:38:46 | NULL | NULL |
- | 1198930 | reliance | 1 | CRDT | 100 | 0 | 0.00 | NULL | 2019-01-17 20:38:53 | NULL | NULL |
- | 1198945 | reliance | 3 | DBIT | 250 | 0 | 0.00 | reseller-Maggi | 2019-01-17 20:51:14 | NULL | NULL |
- | 1198957 | reliance | 5 | DBIT | 100 | 0 | 0.00 | reseller-VMS001 | 2019-01-17 20:56:01 | NULL | NULL |
- | 1198987 | reliance | 6 | DBIT | 250 | 0 | 0.00 | reseller-Kaniz | 2019-01-17 21:36:02 | NULL | NULL |
- | 1198989 | reliance | 7 | DBIT | 50 | 0 | 0.00 | reseller-Kaniz | 2019-01-17 21:36:08 | NULL | NULL |
- | 1199017 | reliance | 9 | DBIT | 500 | 0 | 0.00 | reseller-robina | 2019-01-17 21:54:22 | NULL | NULL |
- | 1199195 | reliance | 10 | DBIT | 100 | 0 | 0.00 | reseller-Jose | 2019-01-18 00:26:55 | NULL | NULL |
- | 1200104 | reliance | 12 | DBIT | 50 | 0 | 0.00 | reseller-super51 | 2019-01-18 15:58:11 | NULL | NULL |
- | 1204762 | reliance | 13 | DBIT | 100 | 0 | 0.00 | reseller-CMTG | 2019-01-21 23:11:42 | NULL | NULL |
- | 1204959 | reliance | 14 | DBIT | 250 | 0 | 0.00 | reseller-Kaniz | 2019-01-22 11:46:05 | NULL | NULL |
- | 1204961 | reliance | 15 | DBIT | 50 | 0 | 0.00 | reseller-Kaniz | 2019-01-22 11:46:13 | NULL | NULL |
- | 1205531 | reliance | 16 | DBIT | 100 | 0 | 0.00 | reseller-Farooq1 | 2019-01-22 20:21:34 | NULL | NULL |
- | 1206744 | reliance | 17 | DBIT | 100 | 0 | 0.00 | reseller-Jose | 2019-01-23 19:47:21 | NULL | NULL |
- | 1207206 | reliance | 19 | DBIT | 100 | 0 | 0.00 | reseller-ksf2 | 2019-01-24 10:53:54 | NULL | NULL |
- | 1207226 | reliance | 20 | DBIT | 100 | 0 | 0.00 | reseller-mayank | 2019-01-24 11:12:50 | NULL | NULL |
- | 1207228 | reliance | 21 | DBIT | 50 | 0 | 0.00 | reseller-ipsa | 2019-01-24 11:13:02 | NULL | NULL |
- | 1207250 | reliance | 22 | DBIT | 57 | 0 | 0.00 | reseller-ipsa | 2019-01-24 11:20:13 | NULL | NULL |
- | 1210742 | reliance | 23 | DBIT | 100 | 0 | 0.00 | reseller-Jose | 2019-01-27 11:13:45 | NULL | NULL |
- | 1211292 | reliance | 24 | DBIT | 25 | 0 | 0.00 | reseller-Kahlon | 2019-01-27 19:51:30 | NULL | NULL |
- | 1213009 | akm | 0 | CRDT | 100 | 0 | 0.00 | NULL | 2019-01-29 13:52:01 | NULL | NULL |
- | 1213010 | reliance | 25 | DBIT | 100 | 0 | 0.00 | reseller-akm | 2019-01-29 13:52:01 | NULL | NULL |
- | 1213013 | akm | 1 | CRDT | 100 | 0 | 0.00 | NULL | 2019-01-29 13:53:17 | NULL | NULL |
- | 1213014 | reliance | 27 | DBIT | 100 | 0 | 0.00 | reseller-akm | 2019-01-29 13:53:17 | NULL | NULL |
- | 1213016 | reliance | 28 | DBIT | 500 | 0 | 0.00 | reseller-kumar007 | 2019-01-29 13:54:19 | NULL | NULL |
- | 1213018 | reliance | 29 | DBIT | 250 | 0 | 0.00 | reseller-kumar007 | 2019-01-29 13:54:32 | NULL | NULL |
- | 1213111 | akm | 3 | DBIT | 6 | 0 | NULL | z-001 | 2019-01-29 15:41:24 | 2019-01-29 00:00:00 | 2019-08-03 00:00:00 |
- | 1214156 | akm | 5 | DBIT | 6 | 0 | NULL | za002 | 2019-01-30 14:42:00 | 2019-01-30 00:00:00 | 2019-08-04 00:00:00 |
- | 1214447 | akm | 7 | DBIT | 3 | 0 | NULL | za003 | 2019-01-30 20:32:11 | 2019-01-30 00:00:00 | 2019-05-03 00:00:00 |
- | 1215042 | reliance | 30 | DBIT | 50 | 0 | 0.00 | reseller-3024786 | 2019-01-31 11:46:51 | NULL | NULL |
- | 1215239 | akm | 9 | DBIT | 6 | 0 | NULL | za004 | 2019-01-31 15:52:17 | 2019-01-31 00:00:00 | 2019-08-05 00:00:00 |
- | 1215288 | akm | 11 | DBIT | 6 | 0 | NULL | za004 | 2019-01-31 16:30:47 | 2019-08-06 00:00:00 | 2020-02-06 00:00:00 |
- | 1215995 | akm | 13 | DBIT | 6 | 0 | NULL | za005 | 2019-02-01 11:23:59 | 2019-02-01 00:00:00 | 2019-08-06 00:00:00 |
- | 1215997 | akm | 15 | DBIT | 6 | 0 | NULL | za006 | 2019-02-01 11:29:03 | 2019-02-01 00:00:00 | 2019-08-06 00:00:00 |
- | 1216003 | akm | 16 | CRDT | 1 | 1 | NULL | resseler-akm | 2019-02-01 11:36:13 | NULL | NULL |
- | 1216670 | akm | 17 | DBIT | 1 | 1 | NULL | za007 | 2019-02-01 21:30:25 | 2019-02-01 00:00:00 | 2019-08-06 00:00:00 |
- | 1216671 | akm | 18 | DBIT | 5 | 0 | NULL | za007 | 2019-02-01 21:30:25 | 2019-02-01 00:00:00 | 2019-08-06 00:00:00 |
- | 1216985 | reliance | 32 | DBIT | 500 | 0 | 0.00 | reseller-Kaniz | 2019-02-02 10:28:21 | NULL | NULL |
- | 1217487 | akm | 20 | DBIT | 6 | 0 | NULL | za008 | 2019-02-02 17:35:14 | 2019-02-02 00:00:00 | 2019-08-07 00:00:00 |
- | 1218240 | akm | 22 | DBIT | 1 | 0 | NULL | za009 | 2019-02-03 10:51:19 | 2019-02-03 00:00:00 | 2019-03-06 00:00:00 |
- +----------+----------+-------------+------+---------+---------------+--------+-------------------+---------------------+---------------------+---------------------+
- 40 rows in set (2.12 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
