Page 86-navicat Programming Tutorials: Learn navicat Online-php.cn

Article Tags

navicat

Home

Technical articles

Database

navicat

What does navicat do?

Navicat is a set of fast, reliable and relatively cheap database management tools designed to simplify database management and reduce system management costs. It is designed to meet the needs of database administrators, developers and small and medium-sized businesses.

Aug 03, 2019 pm 03:06 PM

navicat

How to solve the 1251 error when establishing connection between mysql and navicat

There are two ways to solve the problem. One is to upgrade the navicat driver; the other is to restore the mysql user login password encryption rule to mysql_native_password.

Aug 03, 2019 pm 03:05 PM

mysqlnavicat1251错误解决

How to uninstall navicat after expiration?

The first step is to open the control panel, find Navicat, and click Uninstall. ||The second step is to download Everything (search tool) for global search and delete all things related to Navicat. ||The third step is to enter regedit in "Run" to enter the registry, find the installation path and delete it.

Aug 03, 2019 pm 02:54 PM

navicat卸载

How to add constraints in navicat

The first step is to open Navicat, connect to mysql, open a database, and click "Design Table". ||The second step is to select "Foreign Key", click the three dots in the field, and select the field to which you want to add a foreign key. ||The third step is to select "Reference Table", select "id" in the reference field, set the deletion time and update time, and then click "Save".

Aug 03, 2019 pm 02:36 PM

navicat约束

How to set up auto-increment in navicat

The first step is to open navicat, connect to mysql, select a table, right-click and select "Design Table". ||The second step is to select a field, right-click and select "Primary Key". ||The third step, after setting the primary key, check "Auto-increment" and finally click "Save".

Aug 03, 2019 pm 02:11 PM

navicat设置自增

What does 1130 mean when navicat appears?

MySQL has only one root user. After changing the root password and selecting MD5, after submitting and logging in again, the error message “Host ‘localhost’ is not allowed to connect to this MySQL server” will appear.

Aug 03, 2019 pm 01:54 PM

navicat1130

How to execute sql in navicat

The first step is to open Navicat, connect to the database and create a database. ||The second step is to select "Query" and then click "New Query". ||The third step is to enter the SQL statement in the query editor and click "Run". ||The fourth step is to right-click "Table" and select "Refresh".

Aug 03, 2019 pm 01:45 PM

navicat执行sql

How to save navicat

The first step is to open Navicat and select "Table". ||The second step is to right-click the database you want to save and click "Dump SQL File". ||The third step is to select the saving path and click "OK" to save. ||The fourth step is to open the dumped file in the destination folder.

Aug 03, 2019 pm 01:31 PM

navicat保存

How to clear database backup in navicat

The first step is to open Navicat, right-click "mysql" and select "Open Connection". ||The second step is to click on the database where the backup is located and select the backup menu. ||The third step is to right-click the backup you want to delete and select "Delete Backup". ||The fourth step is to click "Delete" and then click "OK".

Aug 03, 2019 pm 01:19 PM

navicat清除数据库备份

How to open the database in navicat

Open Navicat, click "Conection" and select "MySQL". ||Enter relevant information, click "Test Connection", and then click "OK". || Return to the main window, right-click the database, click "Open Connection", enter the password and confirm.

Aug 03, 2019 pm 01:04 PM

navicat打开数据库

How to make a form in navicat

The first step is to open Navicat and select "View". ||The second step is to select a database and expand it, and select "Table" in the expanded list. ||The third step, right-click "Table", select "New Table", and then fill in the corresponding fields and field attributes. ||The fourth step is to press ctrl+s to save.

Aug 03, 2019 am 11:49 AM

navicat表格

How to view table fields in navicat

The first step is to open navicat, connect to the mysql database, and click "Table". ||The second step is to select "File" and select "Design Table" from the drop-down menu of the file. ||The third step is to view the field types in the data table in the open table design.

Aug 03, 2019 am 11:34 AM

navicat查看表字段

How to create a table in navicat

The first step is to open Navicat, click "New Database" and name it. ||The second step is to select "Table", right-click "New Table", set the primary key to not be empty, and to increase it automatically. ||The third step is to click "Add Column" to add a new column to the table. After designing the table data, click "Save" to create the table.

Aug 03, 2019 am 11:16 AM

navicat创建表

How to view navicat execution plan

The first step is to open the Navicat tool and connect to the database where SQL needs to be executed. ||The second step is to click "Query" and then "New Query". ||The third step is to select "Run" and then click "Explain". ||The fourth step is to finally select the "Explanation" tab to view the SQL execution plan.

Aug 03, 2019 am 10:51 AM

navicat执行计划查看