|
|
+-----------+--------------------+-------------+-----------+----------------+------------------------------------------+-----------------+---------------------------------------------------------------------------------------------------------+
| c_custkey | c_name | revenue | c_acctbal | n_name | c_address | c_phone | c_comment |
+-----------+--------------------+-------------+-----------+----------------+------------------------------------------+-----------------+---------------------------------------------------------------------------------------------------------+
| 859087 | Customer#000859087 | 795591.1319 | 4009.94 | PERU | i VYSwydv M5ss0b | 27-458-775-5124 | the enticingly regular packages. fluffily |
| 740428 | Customer#000740428 | 774058.5652 | 8832.45 | UNITED KINGDOM | f6GR6VnLK,yXj8mxGUIwXBh6R | 33-486-888-6888 | ual, even dependencies are. s |
| 1121018 | Customer#001121018 | 771017.7419 | 440.07 | FRANCE | kymXkSpb2QJwM0fyG5akNjEpABQ6KMVL | 16-979-738-3029 | gifts. blithely final pinto beans above the ironic requests cajole after the spe |
| 940558 | Customer#000940558 | 757257.8295 | 9296.89 | IRAQ | rbUTQJaBKK | 21-412-697-1127 | l accounts use. quickly ironic platelets according to the bold courts use fluffily along |
| 626548 | Customer#000626548 | 741637.4629 | 8816.29 | CANADA | wC,cqFOqmayHMp5wsz9 | 13-108-148-1920 | ites haggle carefully quickly final packages. slyly unusual instructions are. furiously pending depos |
| 176566 | Customer#000176566 | 740436.4792 | 6653.77 | IRAQ | P6cScNofcMOgN | 21-481-935-8112 | nts. even platelets about the slyly pending theodoli |
| 398209 | Customer#000398209 | 737423.6546 | 8078.60 | BRAZIL | Np9BZBmhKjnV2RyVJDRu3VN2 | 12-677-416-7086 | s requests. carefully idle pinto beans impress. regular, ironic deposits cajole final deposits. furious |
| 105427 | Customer#000105427 | 733099.2779 | 1913.89 | FRANCE | VNa1DaHYUaS5j | 16-588-422-6089 | e blithely instructions. ironic tithes sleep furiously through the fluf |
| 1427804 | Customer#001427804 | 726550.3773 | 5641.37 | ETHIOPIA | w24QdAVFSER | 15-973-207-5120 | boost slyly alongside of the daring deposits. dependencies us |
| 365584 | Customer#000365584 | 721747.2564 | 7085.64 | CANADA | LsxxTCJ2nGrptdL | 13-881-145-1128 | s packages. slyly regular patterns boost bold, unusual accounts. |
| 1391057 | Customer#001391057 | 707403.3930 | -956.13 | ETHIOPIA | wU4WfTvm3zsH99 | 15-744-116-1290 | tes use waters. fluffily special ideas along the regular, ironic |
| 1081033 | Customer#001081033 | 697514.1760 | 8912.66 | VIETNAM | kc17y n5axGKI7vtZZYyPN, 3KURHDzNL5snT | 31-738-534-2032 | he fluffily regular pinto beans. deposits detect thinly. |
| 744874 | Customer#000744874 | 696698.6251 | 269.30 | CHINA | J6yHXhjiLifQYl6S, wNzAWj9QmY4 | 28-380-324-8315 | ld dugouts nag furiously after the always unusual theodolites. quickly unusual |
| 1177250 | Customer#001177250 | 695476.5153 | -622.72 | ROMANIA | qGZWM0sT8ZUXZ | 29-104-754-1207 | dolites sleep quickly ironic packages. silent packages haggle carefully |
| 901693 | Customer#000901693 | 694203.9166 | 4822.73 | VIETNAM | o0EVo9buBfc5ZY,gi4VFvXjWR,qJNhjPHXvx mtY | 31-623-126-9286 | ages sleep above the slyly regular requests. carefully even theodolites after the special, bold accoun |
| 1478164 | Customer#001478164 | 692618.5550 | 9128.79 | IRAN | 2vy4nYJ,WD y0uz7uMvtcRmT2D8HSt4S9CbF | 20-455-516-1410 | usly furiously regular pinto beans. blithely i |
| 236758 | Customer#000236758 | 691176.2952 | 8416.76 | ROMANIA | z eZsbos p u | 29-844-815-1064 | eep furiously: pending deposits boost carefully even, final excuses. even, pendi |
| 553184 | Customer#000553184 | 690088.7148 | 5826.55 | SAUDI ARABIA | ir9Q2bjnZilhFoS8gH4I3 | 30-599-126-7708 | lyly thin forges cajole slyly? regular deposits according to the special, express notornis cajole |
| 1459033 | Customer#001459033 | 683803.2768 | 9049.44 | INDONESIA | ZtmMQwHl3OEEmRMFIeRTDuQhEuDVNaQIl31a | 19-680-834-9042 | he slyly bold accounts. carefully ironic foxes cajole bravely |
| 57454 | Customer#000057454 | 677202.9870 | 9740.34 | ETHIOPIA | 3UuMxx1kC9yhoWNVszz7zfVN9817toLaS | 15-589-139-5007 | e fluffily. express foxes among the slyly final in |
+-----------+--------------------+-------------+-----------+----------------+------------------------------------------+-----------------+---------------------------------------------------------------------------------------------------------+
20 rows in set (46.88 sec)
Empty set (42.21 sec)
+------------+-----------------+----------------+
| l_shipmode | high_line_count | low_line_count |
+------------+-----------------+----------------+
| FOB | 62738 | 93486 |
| MAIL | 62206 | 93979 |
+------------+-----------------+----------------+
2 rows in set (1 min 17.23 sec)
exit
Ctrl-C -- sending "KILL QUERY 1" to server ...
Ctrl-C -- query aborted.
ERROR 1317 (70100): Query execution was interrupted
+---------------+
| promo_revenue |
+---------------+
| 16.6088216759 |
+---------------+
1 row in set (41.71 sec)
+-----------+--------------------+---------------------+-----------------+---------------+
| s_suppkey | s_name | s_address | s_phone | total_revenue |
+-----------+--------------------+---------------------+-----------------+---------------+
| 83966 | Supplier#000083966 | 0ITp9HCIUHEHgWCjeTt | 24-897-113-5492 | 2147201.6871 |
+-----------+--------------------+---------------------+-----------------+---------------+
1 row in set (1 min 22.90 sec)
+----------+---------------------------+--------+--------------+
| p_brand | p_type | p_size | supplier_cnt |
+----------+---------------------------+--------+--------------+
| Brand#33 | STANDARD BURNISHED COPPER | 42 | 116 |
| Brand#51 | PROMO PLATED STEEL | 28 | 104 |
| Brand#11 | ECONOMY ANODIZED COPPER | 28 | 100 |
| Brand#42 | PROMO BURNISHED NICKEL | 27 | 100 |
| Brand#11 | ECONOMY POLISHED COPPER | 41 | 99 |
| Brand#51 | ECONOMY PLATED NICKEL | 10 | 96 |
| Brand#14 | ECONOMY PLATED COPPER | 42 | 95 |
| Brand#43 | MEDIUM PLATED NICKEL | 28 | 95 |
| Brand#11 | LARGE POLISHED COPPER | 10 | 92 |
| Brand#15 | ECONOMY BURNISHED NICKEL | 28 | 92 |
+----------+---------------------------+--------+--------------+
10 rows in set (9.83 sec)
mysql>
mysql> |
|
楼主: 〇〇
IP卡
狗仔卡
楼主
显身卡
发表于 2011-6-10 22:59