Skip to content

Instantly share code, notes, and snippets.

@phanngoc

phanngoc/gist:0a06ba0f286336e64c3b67bb099793de

Last active July 24, 2018 02:41
Show Gist options
  • Save phanngoc/0a06ba0f286336e64c3b67bb099793de to your computer and use it in GitHub Desktop.
Save phanngoc/0a06ba0f286336e64c3b67bb099793de to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select membId from memb where membLoid = "[email protected]";
+---------+
| membId |
+---------+
| 1272314 |
+---------+
1 row in set (0.00 sec)
mysql> select * from MYP.poi_hist where histUsid in (1272314);
+----------+----------+----------+----------+----------+----------+------------+----------+----------+---------------------+----------+----------+
| histId | histType | histUsid | histPoin | histBepo | histAfpo | histVadt | histUspo | histTusr | histTday | histFlag | histRema |
+----------+----------+----------+----------+----------+----------+------------+----------+----------+---------------------+----------+----------+
| 8335566 | 99 | 1272314 | 5000 | 0 | 5000 | 0000-00-00 | 5000 | 592 | 2017-09-26 09:12:49 | 0 | 0 |
| 8520213 | 91 | 1272314 | -400 | 5000 | 4600 | 0000-00-00 | 0 | 1 | 2017-11-29 18:06:18 | 1 | 0 |
| 8520221 | 91 | 1272314 | -597 | 4600 | 4003 | 0000-00-00 | 0 | 1 | 2017-11-29 18:09:20 | 1 | 0 |
| 8520234 | 92 | 1272314 | 400 | 4003 | 4403 | 0000-00-00 | 400 | 1 | 2017-11-29 18:12:36 | 0 | 0 |
| 8520235 | 92 | 1272314 | 597 | 4403 | 5000 | 0000-00-00 | 597 | 1 | 2017-11-29 18:12:51 | 0 | 0 |
| 8520260 | 91 | 1272314 | -700 | 5000 | 4300 | 0000-00-00 | 0 | 1 | 2017-11-29 18:22:50 | 1 | 0 |
| 8520265 | 92 | 1272314 | 700 | 4300 | 5000 | 0000-00-00 | 700 | 1 | 2017-11-29 18:24:43 | 0 | 0 |
| 8532380 | 11 | 1272314 | -400 | 5000 | 4600 | 0000-00-00 | 0 | 1 | 2017-12-01 17:22:30 | 1 | 0 |
| 8532395 | 11 | 1272314 | -250 | 4600 | 4350 | 0000-00-00 | 0 | 1 | 2017-12-01 17:26:19 | 1 | 0 |
| 8532505 | 1 | 1272314 | -154 | 4350 | 4196 | 0000-00-00 | 0 | 1 | 2017-12-01 18:00:48 | 1 | 0 |
| 8546050 | 91 | 1272314 | -2497 | 4196 | 1699 | 0000-00-00 | 0 | 1 | 2017-12-05 11:18:10 | 1 | 0 |
| 8546057 | 92 | 1272314 | 2497 | 1699 | 4196 | 0000-00-00 | 2497 | 1 | 2017-12-05 11:23:26 | 0 | 0 |
| 8546495 | 26 | 1272314 | 1 | 4196 | 4197 | 0000-00-00 | 1 | 1 | 2017-12-05 17:26:30 | 0 | 0 |
| 8757724 | 1 | 1272314 | -309 | 4197 | 3888 | 0000-00-00 | 0 | 1 | 2018-02-09 08:45:35 | 1 | 0 |
| 8757727 | 1 | 1272314 | -300 | 3888 | 3588 | 0000-00-00 | 0 | 1 | 2018-02-09 08:49:57 | 1 | 0 |
| 8757728 | 1 | 1272314 | 300 | 3588 | 3888 | 0000-00-00 | 300 | 1 | 2018-02-09 08:50:52 | 0 | 0 |
| 8757741 | 1 | 1272314 | -2263 | 3888 | 1625 | 0000-00-00 | 0 | 1 | 2018-02-09 09:14:07 | 1 | 0 |
| 8757742 | 99 | 1272314 | 5000 | 1625 | 6625 | 0000-00-00 | 5000 | 592 | 2018-02-09 09:17:08 | 0 | 0 |
| 8757743 | 1 | 1272314 | -590 | 6625 | 6035 | 0000-00-00 | 0 | 1 | 2018-02-09 09:17:48 | 1 | 0 |
| 8757744 | 1 | 1272314 | -980 | 6035 | 5055 | 0000-00-00 | 0 | 1 | 2018-02-09 09:18:20 | 1 | 0 |
| 8759187 | 1 | 1272314 | -77 | 5055 | 4978 | 0000-00-00 | 0 | 1 | 2018-02-09 17:35:17 | 1 | 0 |
| 8760200 | 1 | 1272314 | -300 | 4978 | 4678 | 0000-00-00 | 0 | 1 | 2018-02-09 17:48:08 | 1 | 0 |
| 8760207 | 1 | 1272314 | -100 | 4678 | 4578 | 0000-00-00 | 0 | 1 | 2018-02-09 17:50:33 | 1 | 0 |
| 8806643 | 1 | 1272314 | -200 | 4578 | 4378 | 0000-00-00 | 0 | 1 | 2018-02-24 09:51:28 | 1 | 0 |
| 8808147 | 1 | 1272314 | -77 | 4378 | 4301 | 0000-00-00 | 0 | 1 | 2018-02-24 17:43:14 | 1 | 0 |
| 8808148 | 1 | 1272314 | -100 | 4301 | 4201 | 0000-00-00 | 0 | 1 | 2018-02-24 17:43:34 | 1 | 0 |
| 8808149 | 1 | 1272314 | -205 | 4201 | 3996 | 0000-00-00 | 0 | 1 | 2018-02-24 17:43:45 | 1 | 0 |
| 8808150 | 1 | 1272314 | -300 | 3996 | 3696 | 0000-00-00 | 0 | 1 | 2018-02-24 17:44:00 | 1 | 0 |
| 8808151 | 1 | 1272314 | -300 | 3696 | 3396 | 0000-00-00 | 0 | 1 | 2018-02-24 17:44:11 | 1 | 0 |
| 8808154 | 1 | 1272314 | -200 | 3396 | 3196 | 0000-00-00 | 0 | 1 | 2018-02-24 17:46:04 | 1 | 0 |
| 8810641 | 1 | 1272314 | -200 | 3196 | 2996 | 0000-00-00 | 0 | 1 | 2018-02-26 10:48:35 | 1 | 0 |
| 8819216 | 91 | 1272314 | -37 | 2996 | 2959 | 0000-00-00 | 0 | 1 | 2018-03-01 12:09:04 | 1 | 0 |
| 8820828 | 1 | 1272314 | -100 | 2959 | 2859 | 0000-00-00 | 0 | 1 | 2018-03-01 14:48:12 | 1 | 0 |
| 8820839 | 91 | 1272314 | -47 | 2859 | 2812 | 0000-00-00 | 0 | 1 | 2018-03-01 14:49:41 | 1 | 0 |
| 8820856 | 91 | 1272314 | -50 | 2812 | 2762 | 0000-00-00 | 0 | 1 | 2018-03-01 14:51:46 | 1 | 0 |
| 8820863 | 91 | 1272314 | -50 | 2762 | 2712 | 0000-00-00 | 0 | 1 | 2018-03-01 14:52:48 | 1 | 0 |
| 8821114 | 91 | 1272314 | -87 | 2712 | 2625 | 0000-00-00 | 0 | 1 | 2018-03-01 15:38:04 | 1 | 0 |
| 8821118 | 91 | 1272314 | -37 | 2625 | 2588 | 0000-00-00 | 0 | 1 | 2018-03-01 15:38:57 | 1 | 0 |
| 8821122 | 91 | 1272314 | -37 | 2588 | 2551 | 0000-00-00 | 0 | 1 | 2018-03-01 15:39:44 | 1 | 0 |
| 8821131 | 92 | 1272314 | 50 | 2551 | 2601 | 0000-00-00 | 50 | 1 | 2018-03-01 15:40:27 | 0 | 0 |
| 8821133 | 92 | 1272314 | 50 | 2601 | 2651 | 0000-00-00 | 50 | 1 | 2018-03-01 15:40:35 | 0 | 0 |
| 8821134 | 92 | 1272314 | 47 | 2651 | 2698 | 0000-00-00 | 47 | 1 | 2018-03-01 15:40:43 | 0 | 0 |
| 8821137 | 92 | 1272314 | 37 | 2698 | 2735 | 0000-00-00 | 37 | 1 | 2018-03-01 15:40:59 | 0 | 0 |
| 8821141 | 92 | 1272314 | 37 | 2735 | 2772 | 0000-00-00 | 37 | 1 | 2018-03-01 15:42:07 | 0 | 0 |
| 8821143 | 92 | 1272314 | 37 | 2772 | 2809 | 0000-00-00 | 37 | 1 | 2018-03-01 15:42:13 | 0 | 0 |
| 8821145 | 92 | 1272314 | 87 | 2809 | 2896 | 0000-00-00 | 87 | 1 | 2018-03-01 15:42:20 | 0 | 0 |
| 8830066 | 1 | 1272314 | -77 | 2896 | 2819 | 0000-00-00 | 0 | 1 | 2018-03-02 19:33:29 | 1 | 0 |
| 8837569 | 1 | 1272314 | -300 | 2819 | 2519 | 0000-00-00 | 0 | 1 | 2018-03-05 10:15:46 | 1 | 0 |
| 8837608 | 1 | 1272314 | -100 | 2519 | 2419 | 0000-00-00 | 0 | 1 | 2018-03-05 10:29:40 | 1 | 0 |
| 8837610 | 1 | 1272314 | -300 | 2419 | 2119 | 0000-00-00 | 0 | 1 | 2018-03-05 10:29:59 | 1 | 0 |
| 8837614 | 1 | 1272314 | -77 | 2119 | 2042 | 0000-00-00 | 0 | 1 | 2018-03-05 10:30:13 | 1 | 0 |
| 8837623 | 1 | 1272314 | -300 | 2042 | 1742 | 0000-00-00 | 0 | 1 | 2018-03-05 10:35:12 | 1 | 0 |
| 8837626 | 1 | 1272314 | -309 | 1742 | 1433 | 0000-00-00 | 0 | 1 | 2018-03-05 10:35:25 | 1 | 0 |
| 8837628 | 1 | 1272314 | -380 | 1433 | 1053 | 0000-00-00 | 0 | 1 | 2018-03-05 10:35:36 | 1 | 0 |
| 8837629 | 1 | 1272314 | -590 | 1053 | 463 | 0000-00-00 | 0 | 1 | 2018-03-05 10:35:51 | 1 | 0 |
| 8837633 | 99 | 1272314 | 5000 | 463 | 5463 | 2018-10-29 | 5000 | 592 | 2018-03-05 10:37:07 | 0 | 0 |
| 8837636 | 1 | 1272314 | -720 | 5463 | 4743 | 0000-00-00 | 0 | 1 | 2018-03-05 10:37:23 | 1 | 0 |
| 8837638 | 1 | 1272314 | -378 | 4743 | 4365 | 0000-00-00 | 0 | 1 | 2018-03-05 10:42:18 | 1 | 0 |
| 8838085 | 1 | 1272314 | -300 | 4365 | 4065 | 0000-00-00 | 0 | 1 | 2018-03-05 15:10:52 | 1 | 0 |
| 8838087 | 1 | 1272314 | -300 | 4065 | 3765 | 0000-00-00 | 0 | 1 | 2018-03-05 15:11:06 | 1 | 0 |
| 8842116 | 1 | 1272314 | -100 | 3765 | 3665 | 0000-00-00 | 0 | 1 | 2018-03-06 16:10:42 | 1 | 0 |
| 9148158 | 1 | 1272314 | -77 | 3665 | 3588 | 0000-00-00 | 0 | 1 | 2018-04-02 17:16:34 | 1 | 0 |
| 9461224 | 11 | 1272314 | -250 | 3588 | 3338 | 0000-00-00 | 0 | 1 | 2018-04-21 09:26:22 | 1 | 0 |
| 9518121 | 91 | 1272314 | -2913 | 3338 | 425 | 0000-00-00 | 0 | 1 | 2018-05-02 15:40:30 | 1 | 0 |
| 9519541 | 2 | 1272314 | 0 | 425 | 425 | 0000-00-00 | 0 | 1 | 2018-05-02 17:42:52 | 0 | 0 |
| 9530903 | 99 | 1272314 | -166 | 425 | 259 | 0000-00-00 | 0 | 592 | 2018-05-07 08:14:59 | 1 | 0 |
| 9530905 | 99 | 1272314 | 40 | 259 | 299 | 0000-00-00 | 40 | 592 | 2018-05-07 08:16:22 | 0 | 0 |
| 9530906 | 99 | 1272314 | 5000 | 299 | 5299 | 0000-00-00 | 5000 | 592 | 2018-05-07 08:16:52 | 0 | 0 |
| 9530907 | 11 | 1272314 | -250 | 5299 | 5049 | 0000-00-00 | 0 | 1 | 2018-05-07 08:17:35 | 1 | 0 |
| 9530908 | 99 | 1272314 | 4750 | 5049 | 9799 | 2019-01-07 | 4500 | 592 | 2018-05-07 08:20:39 | 0 | 0 |
| 9530909 | 99 | 1272314 | -8750 | 9799 | 1049 | 0000-00-00 | 0 | 592 | 2018-05-07 08:20:50 | 1 | 0 |
| 9530910 | 99 | 1272314 | -750 | 1049 | 299 | 0000-00-00 | 0 | 592 | 2018-05-07 08:21:01 | 1 | 0 |
| 9531056 | 99 | 1272314 | -49 | 299 | 250 | 0000-00-00 | 0 | 592 | 2018-05-07 10:44:17 | 1 | 0 |
| 9531059 | 99 | 1272314 | 5000 | 250 | 5250 | 2019-01-07 | 0 | 592 | 2018-05-07 10:45:45 | 0 | 0 |
| 9885082 | 6 | 1272314 | 100 | 5250 | 5350 | 2018-06-10 | 0 | 1 | 2018-06-07 10:14:12 | 3 | 0 |
| 9885430 | 6 | 1272314 | 50 | 5350 | 5400 | 2018-06-10 | 0 | 1 | 2018-06-07 12:44:31 | 3 | 0 |
| 9885469 | 6 | 1272314 | 100 | 5400 | 5500 | 2018-06-10 | 0 | 1 | 2018-06-07 12:56:28 | 3 | 0 |
| 9903973 | 98 | 1272314 | -250 | 5500 | 5250 | 0000-00-00 | 0 | 1 | 2018-06-11 01:15:01 | 1 | 0 |
| 9921123 | 6 | 1272314 | 100 | 5250 | 5350 | 2018-06-24 | 0 | 1 | 2018-06-15 15:57:48 | 3 | 0 |
| 9921127 | 6 | 1272314 | 50 | 5350 | 5400 | 2018-06-24 | 0 | 1 | 2018-06-15 15:58:58 | 3 | 0 |
| 9921128 | 6 | 1272314 | 50 | 5400 | 5450 | 2018-06-24 | 0 | 1 | 2018-06-15 15:59:11 | 3 | 0 |
| 9955283 | 98 | 1272314 | -200 | 5450 | 5250 | 0000-00-00 | 0 | 1 | 2018-06-25 01:15:01 | 1 | 0 |
| 9963455 | 60 | 1272314 | 300 | 5250 | 5550 | 2018-06-30 | 0 | 1 | 2018-06-27 12:28:32 | 3 | 0 |
| 10035429 | 98 | 1272314 | -300 | 5550 | 5250 | 0000-00-00 | 0 | 1 | 2018-07-01 01:15:01 | 1 | 0 |
| 10156199 | 60 | 1272314 | 300 | 5250 | 5550 | 2018-07-16 | 0 | 1 | 2018-07-13 11:30:41 | 3 | 0 |
| 10258794 | 98 | 1272314 | -300 | 5550 | 5250 | 0000-00-00 | 0 | 1 | 2018-07-17 01:15:01 | 1 | 0 |
+----------+----------+----------+----------+----------+----------+------------+----------+----------+---------------------+----------+----------+
86 rows in set (0.00 sec)
Raw
gistfile2.txt
mysql> select membId from memb where membLoid = "[email protected]";
+---------+
| membId |
+---------+
| 1318442 |
+---------+
1 row in set (0.00 sec)
mysql> select * from MYP.poi_hist where histUsid in (1318442)
-> ;
+---------+----------+----------+----------+----------+----------+------------+----------+----------+---------------------+----------+----------+
| histId | histType | histUsid | histPoin | histBepo | histAfpo | histVadt | histUspo | histTusr | histTday | histFlag | histRema |
+---------+----------+----------+----------+----------+----------+------------+----------+----------+---------------------+----------+----------+
| 8477655 | 99 | 1318442 | 2000 | 0 | 2000 | 0000-00-00 | 2000 | 622 | 2017-11-15 15:12:17 | 0 | 0 |
| 8477658 | 91 | 1318442 | -1355 | 2000 | 645 | 0000-00-00 | 0 | 1 | 2017-11-15 15:16:12 | 1 | 0 |
| 8477669 | 92 | 1318442 | 1355 | 645 | 2000 | 0000-00-00 | 1355 | 1 | 2017-11-15 15:23:33 | 0 | 0 |
| 8477678 | 99 | 1318442 | -2000 | 2000 | 0 | 0000-00-00 | 0 | 622 | 2017-11-15 15:28:44 | 0 | 0 |
| 8477696 | 99 | 1318442 | 2000 | 0 | 2000 | 0000-00-00 | 2000 | 622 | 2017-11-15 15:36:45 | 0 | 0 |
| 8477706 | 91 | 1318442 | -1427 | 2000 | 573 | 0000-00-00 | 0 | 1 | 2017-11-15 15:41:19 | 1 | 0 |
| 8477716 | 92 | 1318442 | 1427 | 573 | 2000 | 0000-00-00 | 1427 | 1 | 2017-11-15 15:43:57 | 0 | 0 |
| 8477720 | 99 | 1318442 | -2000 | 2000 | 0 | 0000-00-00 | 0 | 622 | 2017-11-15 15:47:09 | 0 | 0 |
| 8520192 | 99 | 1318442 | 300 | 0 | 300 | 2019-01-15 | 100 | 622 | 2017-11-29 17:53:22 | 0 | 0 |
| 8520200 | 91 | 1318442 | -100 | 300 | 200 | 0000-00-00 | 0 | 1 | 2017-11-29 17:57:56 | 1 | 0 |
| 8520207 | 92 | 1318442 | 100 | 200 | 300 | 2019-01-15 | 0 | 1 | 2017-11-29 18:02:46 | 0 | 0 |
+---------+----------+----------+----------+----------+----------+------------+----------+----------+---------------------+----------+----------+
11 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment