Shulou(Shulou.com)06/01 Report--

This article is about how to use navicat for mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

How do I use navicat for mysql?

Double-click the shortcut on the desktop to launch "Navicat for MySQL", and the startup interface is shown in the following figure:

Enter the main program interface, as shown in the following figure:

Click the "Connection" connection button to open the "New Connection" new connection dialog box, as shown in the following figure:

Enter "Connection Name", "Password", click the "Test COnnection" button, pop up the "Connection Successful" dialog box, OK, the connection is created successfully.

Create a new database

Double-click the connection you just created to expand the node to display the existing database, as shown in the following figure:

Right-click on the connection "localhost" or in the space-> New Database, as shown in the following figure:

Enter the database name, select "Character set", you can enter "utf8" in the "Character set" box, the software will automatically complete, Collection can be left blank, click the "OK" button, the database is created successfully.

New table

Double-click the database you just created to expand, and right-click Tables-> New Table, as shown in the following figure:

The ID field is relatively critical. It is usually set to self-increasing "Auto Increment" and the primary key "Primary Key". Click "Add Field" to add a field line. When the field is set up, you can click the "Save" button to save the data table, as shown in the following figure:

Insert data

Right-click the datasheet you just created-> Open Table, as shown in the following figure:

Click the "plus" button to add a row, and the date field can be selected by clicking the button. After completing the data, you need to click the "check sign" button to save, as shown in the following figure:

Thank you for reading! About how to use navicat for mysql to share here, I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.