bin/mysql -uroot -S /tmp/mysql_ushastry.sock < world.sql bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.11 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use world Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +-----------------+ | Tables_in_world | +-----------------+ | city | | country | | countrylanguage | +-----------------+ 3 rows in set (0.00 sec) mysql> select name,countrycode,population,sum(population) over (partition by countrycode) as sum from city; +------------------------------------+-------------+------------+-----------+ | name | countrycode | population | sum | +------------------------------------+-------------+------------+-----------+ | Oranjestad | ABW | 29034 | 29034 | | Kabul | AFG | 1780000 | 2332100 | | Qandahar | AFG | 237500 | 2332100 | | Herat | AFG | 186800 | 2332100 | | Mazar-e-Sharif | AFG | 127800 | 2332100 | | Luanda | AGO | 2022000 | 2561600 | | Huambo | AGO | 163100 | 2561600 | | Lobito | AGO | 130000 | 2561600 | | Benguela | AGO | 128300 | 2561600 | | Namibe | AGO | 118200 | 2561600 | | South Hill | AIA | 961 | 1556 | | The Valley | AIA | 595 | 1556 | | Tirana | ALB | 270000 | 270000 | | Andorra la Vella | AND | 21189 | 21189 | | Willemstad | ANT | 2345 | 2345 | | Dubai | ARE | 669181 | 1728336 | | Abu Dhabi | ARE | 398695 | 1728336 | | Sharja | ARE | 320095 | 1728336 | | al-Ayn | ARE | 225970 | 1728336 | | Ajman | ARE | 114395 | 1728336 | | Buenos Aires | ARG | 2982146 | 19996563 | | La Matanza | ARG | 1266461 | 19996563 | | Córdoba | ARG | 1157507 | 19996563 | | Rosario | ARG | 907718 | 19996563 | | Lomas de Zamora | ARG | 622013 | 19996563 | | Quilmes | ARG | 559249 | 19996563 | | Almirante Brown | ARG | 538918 | 19996563 | | La Plata | ARG | 521936 | 19996563 | | Mar del Plata | ARG | 512880 | 19996563 | | San Miguel de Tucumán | ARG | 470809 | 19996563 | | Lanús | ARG | 469735 | 19996563 | | Merlo | ARG | 463846 | 19996563 | | General San Martín | ARG | 422542 | 19996563 | | Salta | ARG | 367550 | 19996563 | | Moreno | ARG | 356993 | 19996563 | | Santa Fé | ARG | 353063 | 19996563 | | Avellaneda | ARG | 353046 | 19996563 | | Tres de Febrero | ARG | 352311 | 19996563 | | Morón | ARG | 349246 | 19996563 | | Florencio Varela | ARG | 315432 | 19996563 | | San Isidro | ARG | 306341 | 19996563 | | Tigre | ARG | 296226 | 19996563 | | Malvinas Argentinas | ARG | 290335 | 19996563 | | Vicente López | ARG | 288341 | 19996563 | | Berazategui | ARG | 276916 | 19996563 | | Corrientes | ARG | 258103 | 19996563 | | San Miguel | ARG | 248700 | 19996563 | | Bahía Blanca | ARG | 239810 | 19996563 | | Esteban Echeverría | ARG | 235760 | 19996563 | | Resistencia | ARG | 229212 | 19996563 | | José C. Paz | ARG | 221754 | 19996563 | | Paraná | ARG | 207041 | 19996563 | | Godoy Cruz | ARG | 206998 | 19996563 | | Posadas | ARG | 201273 | 19996563 | | Guaymallén | ARG | 200595 | 19996563 | | Santiago del Estero | ARG | 189947 | 19996563 | | San Salvador de Jujuy | ARG | 178748 | 19996563 | | Hurlingham | ARG | 170028 | 19996563 | | Neuquén | ARG | 167296 | 19996563 | | Ituzaingó | ARG | 158197 | 19996563 | | San Fernando | ARG | 153036 | 19996563 | | Formosa | ARG | 147636 | 19996563 | | Las Heras | ARG | 145823 | 19996563 | | La Rioja | ARG | 138117 | 19996563 | | San Fernando del Valle de Cata | ARG | 134935 | 19996563 | | Río Cuarto | ARG | 134355 | 19996563 | | Comodoro Rivadavia | ARG | 124104 | 19996563 | | Mendoza | ARG | 123027 | 19996563 | | San Nicolás de los Arroyos | ARG | 119302 | 19996563 | | San Juan | ARG | 119152 | 19996563 | | Escobar | ARG | 116675 | 19996563 | | Concordia | ARG | 116485 | 19996563 | | Pilar | ARG | 113428 | 19996563 | | San Luis | ARG | 110136 | 19996563 | | Ezeiza | ARG | 99578 | 19996563 | | San Rafael | ARG | 94651 | 19996563 | | Tandil | ARG | 91101 | 19996563 | | Yerevan | ARM | 1248700 | 1633100 | | Gjumri | ARM | 211700 | 1633100 | | Vanadzor | ARM | 172700 | 1633100 | | Tafuna | ASM | 5200 | 7523 | | Fagatogo | ASM | 2323 | 7523 | | Saint John´s | ATG | 24000 | 24000 | | Sydney | AUS | 3276207 | 11313666 | | Melbourne | AUS | 2865329 | 11313666 | | Brisbane | AUS | 1291117 | 11313666 | | Perth | AUS | 1096829 | 11313666 | | Adelaide | AUS | 978100 | 11313666 | | Canberra | AUS | 322723 | 11313666 | | Gold Coast | AUS | 311932 | 11313666 | | Newcastle | AUS | 270324 | 11313666 | | Central Coast | AUS | 227657 | 11313666 | | Wollongong | AUS | 219761 | 11313666 | | Hobart | AUS | 126118 | 11313666 | | Geelong | AUS | 125382 | 11313666 | | Townsville | AUS | 109914 | 11313666 | | Cairns | AUS | 92273 | 11313666 | | Wien | AUT | 1608144 | 2384273 | | Graz | AUT | 240967 | 2384273 | | Linz | AUT | 188022 | 2384273 | | Salzburg | AUT | 144247 | 2384273 | | Innsbruck | AUT | 111752 | 2384273 | | Klagenfurt | AUT | 91141 | 2384273 | | Baku | AZE | 1787800 | 2464000 | | Gäncä | AZE | 299300 | 2464000 | | Sumqayit | AZE | 283000 | 2464000 | | Mingäçevir | AZE | 93900 | 2464000 | | Bujumbura | BDI | 300000 | 300000 | | Antwerpen | BEL | 446525 | 1609322 | | Gent | BEL | 224180 | 1609322 | | Charleroi | BEL | 200827 | 1609322 | | Liège | BEL | 185639 | 1609322 | | Bruxelles [Brussel] | BEL | 133859 | 1609322 | | Brugge | BEL | 116246 | 1609322 | | Schaerbeek | BEL | 105692 | 1609322 | | Namur | BEL | 105419 | 1609322 | | Mons | BEL | 90935 | 1609322 | | Cotonou | BEN | 536827 | 968503 | | Porto-Novo | BEN | 194000 | 968503 | | Djougou | BEN | 134099 | 968503 | | Parakou | BEN | 103577 | 968503 | | Ouagadougou | BFA | 824000 | 1229000 | | Bobo-Dioulasso | BFA | 300000 | 1229000 | | Koudougou | BFA | 105000 | 1229000 | | Dhaka | BGD | 3612850 | 8569906 | | Chittagong | BGD | 1392860 | 8569906 | | Khulna | BGD | 663340 | 8569906 | | Rajshahi | BGD | 294056 | 8569906 | | Narayanganj | BGD | 202134 | 8569906 | | Rangpur | BGD | 191398 | 8569906 | | Mymensingh | BGD | 188713 | 8569906 | | Barisal | BGD | 170232 | 8569906 | | Tungi | BGD | 168702 | 8569906 | | Jessore | BGD | 139710 | 8569906 | | Comilla | BGD | 135313 | 8569906 | | Nawabganj | BGD | 130577 | 8569906 | | Dinajpur | BGD | 127815 | 8569906 | | Bogra | BGD | 120170 | 8569906 | | Sylhet | BGD | 117396 | 8569906 | | Brahmanbaria | BGD | 109032 | 8569906 | | Tangail | BGD | 106004 | 8569906 | | Jamalpur | BGD | 103556 | 8569906 | | Pabna | BGD | 103277 | 8569906 | | Naogaon | BGD | 101266 | 8569906 | | Sirajganj | BGD | 99669 | 8569906 | | Narsinghdi | BGD | 98342 | 8569906 | | Saidpur | BGD | 96777 | 8569906 | | Gazipur | BGD | 96717 | 8569906 | | Sofija | BGR | 1122302 | 2696915 | | Plovdiv | BGR | 342584 | 2696915 | | Varna | BGR | 299801 | 2696915 | | Burgas | BGR | 195255 | 2696915 | | Ruse | BGR | 166467 | 2696915 | | Stara Zagora | BGR | 147939 | 2696915 | | Pleven | BGR | 121952 | 2696915 | | Sliven | BGR | 105530 | 2696915 | | Dobric | BGR | 100399 | 2696915 | | Šumen | BGR | 94686 | 2696915 | | al-Manama | BHR | 148000 | 148000 | | Nassau | BHS | 172000 | 172000 | | Sarajevo | BIH | 360000 | 599106 | | Banja Luka | BIH | 143079 | 599106 | | Zenica | BIH | 96027 | 599106 | | Minsk | BLR | 1674000 | 4741000 | | Gomel | BLR | 475000 | 4741000 | | Mogiljov | BLR | 356000 | 4741000 | | Vitebsk | BLR | 340000 | 4741000 | | Grodno | BLR | 302000 | 4741000 | | Brest | BLR | 286000 | 4741000 | | Bobruisk | BLR | 221000 | 4741000 | | Baranovitši | BLR | 167000 | 4741000 | | Borisov | BLR | 151000 | 4741000 | | Pinsk | BLR | 130000 | 4741000 | | Orša | BLR | 124000 | 4741000 | | Mozyr | BLR | 110000 | 4741000 | | Novopolotsk | BLR | 106000 | 4741000 | | Lida | BLR | 101000 | 4741000 | | Soligorsk | BLR | 101000 | 4741000 | | Molodetšno | BLR | 97000 | 4741000 | | Belize City | BLZ | 55810 | 62915 | | Belmopan | BLZ | 7105 | 62915 | | Saint George | BMU | 1800 | 3000 | | Hamilton | BMU | 1200 | 3000 | | Santa Cruz de la Sierra | BOL | 935361 | 3378644 | . | Kitwe | ZMB | 288600 | 2473500 | | Kabwe | ZMB | 154300 | 2473500 | | Chingola | ZMB | 142400 | 2473500 | | Mufulira | ZMB | 123900 | 2473500 | | Luanshya | ZMB | 118100 | 2473500 | | Harare | ZWE | 1410000 | 2730420 | | Bulawayo | ZWE | 621742 | 2730420 | | Chitungwiza | ZWE | 274912 | 2730420 | | Mount Darwin | ZWE | 164362 | 2730420 | | Mutare | ZWE | 131367 | 2730420 | | Gweru | ZWE | 128037 | 2730420 | +------------------------------------+-------------+------------+-----------+ 4079 rows in set (0.02 sec) mysql> mysql> -- Shell session - OL7 [umshastr@hod03]~: cd /export/umesh/server/binaries/GABuilds/90534/mysql-shell-8.0.11 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/90534/mysql-shell-8.0.11: bin/mysqlsh --log-level=debug3 MySQL Shell 8.0.11 Copyright (c) 2016, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help' or '\?' for help; '\quit' to exit. MySQL JS > \c root@localhost Creating a session to 'root@localhost' Enter password: Fetching schema names for autocompletion... Press ^C to stop. Your MySQL connection id is 10 (X protocol) Server version: 8.0.11 MySQL Community Server - GPL No default schema selected; type \use to set one. MySQL localhost:33060+ ssl JS > MySQL localhost:33060+ ssl JS > \sql Switching to SQL mode... Commands end with ; MySQL localhost:33060+ ssl SQL > \use world Default schema set to `world`. Fetching table and column names from `world` for auto-completion... Press ^C to stop. MySQL localhost:33060+ ssl world SQL > select name,countrycode,population,sum(population) over (partition by countrycode) as sum from city; +-----------------------------------+-------------+------------+-----------+ | name | countrycode | population | sum | +-----------------------------------+-------------+------------+-----------+ | Oranjestad | ABW | 29034 | 29034 | | Kabul | AFG | 1780000 | 2332100 | | Qandahar | AFG | 237500 | 2332100 | | Herat | AFG | 186800 | 2332100 | | Mazar-e-Sharif | AFG | 127800 | 2332100 | | Luanda | AGO | 2022000 | 2561600 | | Huambo | AGO | 163100 | 2561600 | | Lobito | AGO | 130000 | 2561600 | | Benguela | AGO | 128300 | 2561600 | | Namibe | AGO | 118200 | 2561600 | | South Hill | AIA | 961 | 1556 | | The Valley | AIA | 595 | 1556 | | Tirana | ALB | 270000 | 270000 | | Andorra la Vella | AND | 21189 | 21189 | | Willemstad | ANT | 2345 | 2345 | | Dubai | ARE | 669181 | 1728336 | | Abu Dhabi | ARE | 398695 | 1728336 | | Sharja | ARE | 320095 | 1728336 | [...] | Mufulira | ZMB | 123900 | 2473500 | | Luanshya | ZMB | 118100 | 2473500 | | Harare | ZWE | 1410000 | 2730420 | | Bulawayo | ZWE | 621742 | 2730420 | | Chitungwiza | ZWE | 274912 | 2730420 | | Mount Darwin | ZWE | 164362 | 2730420 | | Mutare | ZWE | 131367 | 2730420 | | Gweru | ZWE | 128037 | 2730420 | +-----------------------------------+-------------+------------+-----------+ 4079 rows in set (0.0181 sec) MySQL localhost:33060+ ssl world SQL > select 1; +---+ | 1 | +---+ | 1 | +---+ 1 row in set (0.0005 sec) MySQL localhost:33060+ ssl world SQL > -- Shell session - OL7 On win7 MySQL [hod03.no.oracle.com+ ssl/world] SQL> select name,countrycode,population,sum(population) over (partition by ycode) as sum from city; +-----------------------------------+-------------+------------+-----------+ | name | countrycode | population | sum | +-----------------------------------+-------------+------------+-----------+ | Oranjestad | ABW | 29034 | 29034 | | Kabul | AFG | 1780000 | 2332100 | | Qandahar | AFG | 237500 | 2332100 | | Herat | AFG | 186800 | 2332100 | | Mazar-e-Sharif | AFG | 127800 | 2332100 | | Luanda | AGO | 2022000 | 2561600 | | Huambo | AGO | 163100 | 2561600 | | Lobito | AGO | 130000 | 2561600 | | Benguela | AGO | 128300 | 2561600 | | Namibe | AGO | 118200 | 2561600 | | South Hill | AIA | 961 | 1556 | | The Valley | AIA | 595 | 1556 | | Tirana | ALB | 270000 | 270000 | | Andorra la Vella | AND | 21189 | 21189 | | Willemstad | ANT | 2345 | 2345 | | Dubai | ARE | 669181 | 1728336 | [...] | Bulawayo | ZWE | 621742 | 2730420 | | Chitungwiza | ZWE | 274912 | 2730420 | | Mount Darwin | ZWE | 164362 | 2730420 | | Mutare | ZWE | 131367 | 2730420 | | Gweru | ZWE | 128037 | 2730420 | +-----------------------------------+-------------+------------+-----------+ 4079 rows in set (1.4129 sec) MySQL [hod03.no.oracle.com+ ssl/world] SQL>