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