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

Article Tags

navicat

Home

Technical articles

Database

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备份同步