Navicat-Database management tools
First, Introduction
"1"Navicat is a powerful Visual database management tool for developing and managing databases such as Mysql,oracle,sql Server,sqlite
"2"Navicat Premium is a Mac database management tool, connect this tool to the database, you can see the details of various databases
"3" official website: https://www.navicat.com
second, the installation
Reference Link: https://www.navicat.com/download/navicat-for-mysql
Iii. Use of the tutorial (MAC)
"1" database Connection (MySQL): The connection name casually fills in, the IP address, the port number, the user names have the corresponding default value
"2" New database: connection name right key, you can create a database
"3" new table: table Right key, can create datasheet
Table right, you can choose "Design Table"
"4" set character encoding: You can set the character encoding in an option
"5" Query Editor: two ways to access the Query Editor
To enter the query Editor, you can edit and execute the SQL statement
"6" Reference link
http://www.jianshu.com/p/326c1aaa1052
http://www.weiruoyu.cn/?p=175