- 使用時需要找到mysql所在的bin目錄
tianqingsedengyanyu:~ fengfeng$ /usr/local/mysql/bin/mysql -u root -p
Enter password:
- alias
tianqingsedengyanyu:~ fengfeng$ vim ~/.bash_profile
# Add environment variable COCOS_CONSOLE_ROOT for cocos2d-x
export COCOS_CONSOLE_ROOT=/Applications/Cocos/Cocos2d-x/cocos2d-x-3.10/tools/cocos2d-console/bin
export PATH=$COCOS_CONSOLE_ROOT:$PATH
# Add environment variable COCOS_X_ROOT for cocos2d-x
export COCOS_X_ROOT=/Applications/Cocos/Cocos2d-x
export PATH=$COCOS_X_ROOT:$PATH
# Add environment variable COCOS_TEMPLATES_ROOT for cocos2d-x
export COCOS_TEMPLATES_ROOT=/Applications/Cocos/Cocos2d-x/cocos2d-x-3.10/templates
export PATH=$COCOS_TEMPLATES_ROOT:$PATH
alias mysql='/usr/local/mysql/bin/mysql';
~
~
~
~
~
~
~
:wq!
更改別名后 使用下面命令既穆，使 ~/.bash_profile 生效
tianqingsedengyanyu:~ fengfeng$ source ~/.bash_profile
tianqingsedengyanyu:~ fengfeng$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 64
Server version: 5.7.16 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, 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>
- 退出mysql
mysql> quit
Bye
tianqingsedengyanyu:~ fengfeng$
- 開啟、終止 mysql 服務(wù)
tianqingsedengyanyu:~ fengfeng$ sudo /usr/local/mysql/support-files/mysql.server start
Password:
Starting MySQL
. SUCCESS!
tianqingsedengyanyu:~ fengfeng$
tianqingsedengyanyu:~ fengfeng$ sudo /usr/local/mysql/support-files/mysql.server stop
Shutting down MySQL
. SUCCESS!
tianqingsedengyanyu:~ fengfeng$
- 重置密碼
mysql> set password = password('123456');
- 選擇數(shù)據(jù)庫
mysql> use eshop;
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>
- 查看數(shù)據(jù)庫中的表
mysql> show tables;
- 查看表字段名注釋
mysql> desc eshop_points_order;
+----------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+----------------+
| point_orderid | int(11) | NO | PRI | NULL | auto_increment |
| point_ordersn | varchar(20) | NO | | NULL | |
| point_buyerid | int(11) | NO | | NULL | |
| point_buyername | varchar(50) | NO | | NULL | |
| point_buyeremail | varchar(100) | NO | | NULL | |
| point_addtime | int(11) | NO | | NULL | |
| point_shippingtime | int(11) | YES | | NULL | |
| point_shippingcode | varchar(50) | YES | | NULL | |
| point_shipping_ecode | varchar(30) | YES | | NULL | |
| point_finnshedtime | int(11) | YES | | NULL | |
| point_allpoint | int(11) | NO | | 0 | |
| point_ordermessage | varchar(300) | YES | | NULL | |
| point_orderstate | int(11) | NO | | 20 | |
+----------------------+--------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)
mysql>
不定期更新 不合適的地方 還請指點~ 感激不盡
