A tutorial for simple use of Navicat For MySQL

1. The prerequisite is that the MySQL database must be installed first (for installing MySQL database under Mac, see the previous article)

two。 Install Navicat

3. Click on the top left corner of navicate: connect-> MySQL- > pre-test link. If you are prompted to connect successfully, you can fill in the connection name and click on the connection.

Double-click the connection you just created and there will be four databases below

Use the naVicate command line to see how many databases there are under the connection: first select connection-> tools above the navigation bar-> command line interface, and a command window-> enter: show databases; (be sure to follow it with a semicolon) will pop up.

Use related databases: use test

Create a new database: create database xxx; or right-click under the connection and select New Database. Note: if you do not have your own character set at the time of creation, the system will default to the character set at the time of installation (utf8). Now the character set is generally utf8.

See how many tables there are under the database: show tables

View the structure of the table: desc table name

Delete a database: drop database database name

Create a new database: create database database name

1. Access to a database: use xxx

2.create table student (id BIGINT, name VARCHAR (20), age INT)

If the keyword of the database is used in creating the table.

For example, create a new order table: (order), but order is the keyword in the database (sorting is used).

Table name: t_order, if the cost uses the word order. At this point, enclose it with anti-prime (`), `order`.

Delete table: drop table student

When creating a table using the tool: set to the next space (tab)

Modify the table: select the table first, and then right-click to select the design table

Summary

The above is a simple tutorial on the use of Navicat For MySQL introduced by the editor. I hope it will be helpful to you. If you have any questions, you are welcome to leave a message. The editor will reply you in time!