docker操作mysql

admin@DESKTOP-34651H7 MINGW64 /d/internship/project/isuwang-soa-etrade (order_seq)

$ docker restart mysql

mysql

admin@DESKTOP-34651H7 MINGW64 /d/internship/project/isuwang-soa-etrade (order_seq)

$ docker exec -it mysql bash

cannot enable tty mode on non tty input

admin@DESKTOP-34651H7 MINGW64 /d/internship/project/isuwang-soa-etrade (order_seq)

$ docker-machine.exe ssh sandbox

                        ##         .

                  ## ## ##        ==

               ## ## ## ## ##    ===

           /"""""""""""""""""\___/ ===

      ~~~ {~~ ~~~~ ~~~ ~~~~ ~~~ ~ /  ===- ~~~

           \______ o           __/

             \    \         __/

              \____\_______/

_                 _   ____     _            _

| |__   ___   ___ | |_|___ \ __| | ___   ___| | _____ _ __

| '_ \ / _ \ / _ \| __| __) / _` |/ _ \ / __| |/ / _ \ '__|

| |_) | (_) | (_) | |_ / __/ (_| | (_) | (__|   <  __/ |

|_.__/ \___/ \___/ \__|_____\__,_|\___/ \___|_|\_\___|_|

Boot2Docker version 1.11.2, build HEAD : a6645c3 - Wed Jun  1 22:59:51 UTC 2016

Docker version 1.11.2, build b9f10c9

docker@sandbox:~$ docker exec -it mysql bash

[root@934b686cc344 /]#

[root@934b686cc344 /]# mysql -uroot -proot -h 192.168.99.100

Warning: Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 5.6.26-log MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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 orderdb;

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> select * from etrade_target_mappings limit 10;

+-----------+--------------+--------------+----------------+-------------------------+------------+-------------------------+------------+-------+

| target_id | commodity_id | warehouse_id | warehouse_name | created_at              | created_by | updated_at              | updated_by | valid |

+-----------+--------------+--------------+----------------+-------------------------+------------+-------------------------+------------+-------+

|       111 | 111          |            1 | ?????          | 2016-07-26 17:51:10.000 |       NULL | 2016-07-26 17:51:10.000 |       NULL |     1 |

+-----------+--------------+--------------+----------------+-------------------------+------------+-------------------------+------------+-------+

1 row in set (0.00 sec)

mysql> show tables;

+-----------------------------+

| Tables_in_orderdb           |

+-----------------------------+

| action_log                  |

| auction_bid_records         |

| auction_purchase_items      |

| auction_target_summaries    |

| auction_targets             |

| auction_wined_records       |

| etrade_bid_limit            |

| etrade_bids                 |

| etrade_dealt_bids           |

| etrade_favorite_targets     |

| etrade_seq                  |

| etrade_special_shows        |

| etrade_target_mappings      |

| etrade_target_summaries     |

| etrade_targets              |

| finance_modify_process      |

| gl_account                  |

| global_scheduler_locks      |

| global_transaction_process  |

| global_transactions         |

| invoice_batch_cornets       |

| invoice_contract_relations  |

| invoice_details             |

| invoices                    |

| list_items                  |

| logistics                   |

| order_additional_contracts  |

| order_attachments           |

| order_contracts             |

| order_coupons               |

| order_deliveries            |

| order_deliveries_result     |

| order_delivery_driver       |

| order_delivery_items        |

| order_fees                  |

| order_fees_0314             |

| order_fees_160329           |

| order_finance_settle        |

| order_finance_settle_0314   |

| order_finance_settle_160329 |

| order_finances              |

| order_finances_0314         |

| order_finances_160329       |

| order_items                 |

| order_no_sequence           |

| order_profit_attach         |

| order_receipts              |

| orders                      |

| product_deals               |

| purchase_order              |

| purchase_order_fees         |

| purchase_order_item         |

| purchase_order_payments     |

| receipt_accounts            |

| receipt_line_allocates      |

| receipt_lines               |

| settle                      |

| settle_0314                 |

| settle_160329               |

| settle_details              |

| settle_details_0305         |

| settle_details_0314         |

| settle_details_160329       |

| settle_journal              |

| settle_journal_0305         |

| settle_journal_0314         |

| settle_journal_160329       |

| stock_lines                 |

| stocks                      |

| supplier_limit_lines        |

| supplier_settled            |

| supplier_settled_lines      |

| sync_stock_scheduler        |

+-----------------------------+

73 rows in set (0.00 sec)

mysql> exit

Bye

[root@934b686cc344 /]# exit

exit

docker@sandbox:~$ exit