Skip to content

Instantly share code, notes, and snippets.

@shoji-mochizuki
Last active August 29, 2015 14:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shoji-mochizuki/006c0b9e8cc113289279 to your computer and use it in GitHub Desktop.
Save shoji-mochizuki/006c0b9e8cc113289279 to your computer and use it in GitHub Desktop.
mycliでMySQLコマンドの補完機能を簡単に使う ref: http://qiita.com/shojimotio/items/efc8fce9ce3ebe179897
mysql root@localhost:wordpressdb> SELECT * FROM
wp_commentmeta
wp_comments
wp_links
wp_options
wp_postmeta
wp_posts
wp_term_relationships
$ sudo yum install python-pip
$ sudo pip install mycli
$ mycli -u root -p
Password:
Version: 1.0.1
Chat: https://gitter.im/dbcli/mycli
Mail: https://groups.google.com/forum/#!forum/mycli-users
Home: http://mycli.net
Thanks to the contributor - Lewis Peckover
mysql root@localhost:(none)>
mysql root@localhost:(none)> show
AUTHORS
BINARY LOGS
BINLOG EVENTS
CHARACTER SET
COLLATION
COLUMNS
CONTRIBUTORS
mysql root@localhost:wordpressdb> SELECT * FROM wp_postmeta
+-----------+-----------+-------------------+--------------+
| meta_id | post_id | meta_key | meta_value |
|-----------+-----------+-------------------+--------------|
| 1 | 2 | _wp_page_template | default |
| 2 | 1 | _edit_lock | 1438324456:1 |
+-----------+-----------+-------------------+--------------+
2 rows in set
Command Time: 0.000s
Format Time: 0.001s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment