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

Article Tags

navicat

Home

Technical articles

Database

navicat

How to import sql files into navicat

Open Navicat for MySQL, click "New Link", right-click on any database, and select "New Database". ||Enter the database name and select GBK as the character set. ||Right-click and select "Open Database", drag the sql file into the database, click "Start", and after the run is completed, right-click to refresh.

Aug 03, 2019 am 10:13 AM

sql文件导入navicat

How to connect navicat to mysql

The first step is to install the mysql database. ||The second step is to open Navicat for Mysql. ||The third step, click "connection" to enter the connection interface. ||The fourth step is to enter the relevant information, then click "Test Connection", and finally click "save" to connect.

Aug 03, 2019 am 09:49 AM

navicat连接mysql

How to create a new link in navicat

The first step is to open Navicat and click "Connect". ||The second step is to enter the host name, port, user name and other information in the new connection interface. ||The third step is to authorize the database for the root user, and then click "Connection Test".

Aug 03, 2019 am 09:30 AM

navicat新建链接

How to set up Chinese in navicat

The first step is to open Navicat and click "Tools". ||The second step is to select "Options" in the tool's drop-down menu to enter the options window. ||The third step, select "Font" in the appearance, enter the font window, set all fonts in the font to Chinese fonts, and finally click "OK".

Aug 02, 2019 pm 06:00 PM

navicat设置中文

How to set foreign keys in navicat

Open the database where the data table is located, right-click the database table where you want to add fields, and click "Design Table". ||Click the "Foreign Key" tab and enter the name of the foreign key. ||Set fields, reference databases, reference tables, reference fields, delete operations, and update operations. ||Finally click "Save".

Aug 02, 2019 pm 05:35 PM

navicat设置外键

How to set primary key in navicat

Open the database where the data table is located, right-click the database table where you want to add fields, and click "Design Table". ||Select the field as the primary key, such as the code field. ||Click "Primary Key" under the "Object" menu, and the code field becomes the primary key and is automatically set to non-empty. ||Set the default value of the primary key, comments, etc., and finally click "Save".

Aug 02, 2019 pm 05:23 PM

navicat设置主键

How to use navicat premium

Connect to the MySQL database: Select "Connect", then click "Mysql", set the relevant connection information, and click OK. Query: Click "Query", then select "New", and then enter the SQL statement. View the data table: Double-click "Connection", then double-click "Database", and finally double-click "Table".

Aug 02, 2019 pm 04:35 PM

navicat premium怎么用

What does navicate do?

Navicat is a multi-connection database management tool that can connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server and/or MariaDB databases to make database management more convenient.

Aug 02, 2019 pm 04:15 PM

navicate

Navicat practical functions: data backup and structure synchronization

When we do risky operations on the database, we need to back it up. Every time we go online, there will always be inconsistencies in the online and offline database structures. This article will explain how to use Navicat to easily solve these two problems. .

Jun 19, 2019 pm 03:18 PM

Navicatsql备份同步