Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select odate,boolean from t2 where metric='Adjusted net national income';
- +----------+---------+
- | odate | boolean |
- +----------+---------+
- | 19710000 | 0 |
- | 19720000 | 0 |
- | 19730000 | 0 |
- | 19740000 | 0 |
- | 19750000 | 0 |
- | 19760000 | 0 |
- | 19770000 | 0 |
- | 19780000 | 0 |
- | 19790000 | 0 |
- | 19800000 | 0 |
- | 19810000 | 0 |
- | 19820000 | 0 |
- | 19830000 | 0 |
- | 19840000 | 0 |
- | 19850000 | 0 |
- | 19860000 | 0 |
- | 19870000 | 0 |
- | 19880000 | 0 |
- | 19890000 | 0 |
- | 19900000 | 0 |
- | 19910000 | 0 |
- | 19920000 | 0 |
- | 19930000 | 0 |
- | 19940000 | 0 |
- | 19950000 | 0 |
- | 19960000 | 0 |
- | 19970000 | 0 |
- | 19980000 | 0 |
- | 19990000 | 0 |
- | 20000000 | 0 |
- | 20010000 | 0 |
- | 20020000 | 0 |
- | 20030000 | 0 |
- | 20040000 | 0 |
- | 20050000 | 0 |
- | 20060000 | 0 |
- | 20070000 | 0 |
- | 20080000 | 0 |
- | 20090000 | 0 |
- | 20100000 | 0 |
- | 20110000 | 0 |
- | 20120000 | 0 |
- | 20130000 | 0 |
- | 20140000 | 0 |
- | 20150000 | 0 |
- | 19700000 | 1 |
- | 19710000 | 1 |
- | 19720000 | 1 |
- | 19730000 | 1 |
- | 19740000 | 1 |
- | 19750000 | 1 |
- | 19760000 | 1 |
- | 19770000 | 1 |
- | 19780000 | 1 |
- | 19790000 | 1 |
- | 19800000 | 1 |
- | 19810000 | 1 |
- | 19820000 | 1 |
- | 19830000 | 1 |
- | 19840000 | 1 |
- | 19850000 | 1 |
- | 19860000 | 1 |
- | 19870000 | 1 |
- | 19880000 | 1 |
- | 19890000 | 1 |
- | 19900000 | 1 |
- | 19910000 | 1 |
- | 19920000 | 1 |
- | 19930000 | 1 |
- | 19940000 | 1 |
- | 19950000 | 1 |
- | 19960000 | 1 |
- | 19970000 | 1 |
- | 19980000 | 1 |
- | 19990000 | 1 |
- | 20000000 | 1 |
- | 20010000 | 1 |
- | 20020000 | 1 |
- | 20030000 | 1 |
- | 20040000 | 1 |
- | 20050000 | 1 |
- | 20060000 | 1 |
- | 20070000 | 1 |
- | 20080000 | 1 |
- | 20090000 | 1 |
- | 20100000 | 1 |
- | 20110000 | 1 |
- | 20120000 | 1 |
- | 20130000 | 1 |
- | 20140000 | 1 |
- | 20150000 | 1 |
- | 19700000 | 1 |
- | 19710000 | 1 |
- | 19720000 | 1 |
- | 19730000 | 1 |
- | 19740000 | 1 |
- | 19750000 | 1 |
- | 19760000 | 1 |
- | 19770000 | 1 |
- | 19780000 | 1 |
- | 19790000 | 1 |
- | 19800000 | 1 |
- | 19810000 | 1 |
- | 19820000 | 1 |
- | 19830000 | 1 |
- | 19840000 | 1 |
- | 19850000 | 1 |
- | 19860000 | 1 |
- | 19870000 | 1 |
- | 19880000 | 1 |
- | 19890000 | 1 |
- | 19900000 | 1 |
- | 19910000 | 1 |
- | 19920000 | 1 |
- | 19930000 | 1 |
- | 19940000 | 1 |
- | 19950000 | 1 |
- | 19960000 | 1 |
- | 19970000 | 1 |
- | 19980000 | 1 |
- | 19990000 | 1 |
- | 20000000 | 1 |
- | 20010000 | 1 |
- | 20020000 | 1 |
- | 20030000 | 1 |
- | 20040000 | 1 |
- | 20050000 | 1 |
- | 20060000 | 1 |
- | 20070000 | 1 |
- | 20080000 | 1 |
- | 20090000 | 1 |
- | 20100000 | 1 |
- | 20110000 | 1 |
- | 20120000 | 1 |
- | 20130000 | 1 |
- | 20140000 | 1 |
- | 20150000 | 1 |
- +----------+---------+
- 137 rows in set (0.04 sec)
Add Comment
Please, Sign In to add comment