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

Article Tags

All
web3.0
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Backend Development
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Web Front-end
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Database
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Operation and Maintenance
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Development Tools
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
PHP Framework
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Common Problem
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Other
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Tech
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
CMS Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Java
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
System Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Computer Tutorials
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Hardware Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Mobile Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Software Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache
Mobile Game Tutorial
- Mysql Tutorial
- navicat
- SQL
- Redis
- phpMyAdmin
- Oracle
- MongoDB
- NoSQL database
- Memcached
- cloudera
- memcache

Home

Technical Articles

Database

navicat

How to run navicat

To run navicat, we can double-click the shortcut or find the navicat.exe file in the navicat installation directory, and then double-click it to run navicat.

Aug 20, 2019 am 11:55 AM

navicat

How to extend the 14-day trial period of Navicat?

Press the "Win+R" keys and enter "regedit". ||Delete HKEY_CURRENT_USER\...\Data||Expand HKEY_CURRENT_USER\...\CLSID||Expand each subfolder and delete all Info folders.

Aug 20, 2019 am 11:54 AM

navicat 试用期延长

What should I do if navicat reports error 1025 when setting foreign keys?

Find the foreign key association table and find the foreign key name. ||Delete foreign key constraints. ||Modify the main table (member) id field type. ||Modify the member_id field type of the auxiliary table (address). ||Just replace the deleted foreign key.

Aug 20, 2019 am 11:47 AM

navicat 外键 1025

How to import mysql in navicat

How to import mysql in navicat: First open Navicat for MySQL; then right-click and select New Database; then click OK to see the data you just created; finally right-click and select "Run SQL File" and click Start, mysql file The import will be successful.

Aug 20, 2019 am 11:43 AM

navicat

How to use navicat to connect to mysql

The first step is to open navicat, click "Connect" and select "mysql". ||The second step is to enter relevant information in "General". ||The third step is to make relevant settings in "Advanced". ||The fourth step is to set the verification information in "SSL". ||The fifth step is to click "Connection Test".

Aug 20, 2019 am 11:37 AM

navicat 连接 mysql

How to use navicat for mysql

Create a database: select the connection name, right-click "New Database"; delete a database: select the database to be deleted, right-click "Delete Database"; modify the data table: select the data table, right-click "Design Table", and then edit the fields, data types, integrity constraints, etc.

Aug 20, 2019 am 11:24 AM

navicat mysql

How to export database files in navicat

The first step is to open Navicat and open the database. ||The second step is to select “Backups” and then click “New Backup”. ||The third step, select the file you just backed up, and then right-click "Extract SQL". ||The fourth step is to save the file.

Aug 20, 2019 am 10:44 AM

navicat 导出数据库文件

What should I do if the trial period of Navicat has expired?

Press the "Win+R" keys and enter "regedit". ||Delete HKEY_CURRENT_USER\...\Data||Expand HKEY_CURRENT_USER\...\CLSID||Expand each subfolder and delete all Info folders.

Aug 20, 2019 am 10:30 AM

navicat 试用期

How to open sql file in navicat

Open navicat, right-click and select "New Database". ||Select the character set as gkb. ||Right-click the created database and select "Open Database". ||Drag the .sql file into the database, click "Start" in the pop-up "Run SQL File" dialog box, then right-click and select "Refresh".

Aug 20, 2019 am 10:14 AM

navicat sql文件

How to edit table in navicat

The first step is to open Navicat and connect to the database. ||The second step is to right-click the table to be edited and select "Design Table". ||The third step is to enter the data table and you can see the field types and character sets of the table. You can edit the table on this page.

Aug 20, 2019 am 09:52 AM

navicat 编辑表

How to query the table in navicat

The first step is to create a new table, for example: "article". ||The second step is to click "Query" in Navicat's tab, and then click "New Query". ||The third step is to enter the SQL statement in the query window to search, and then click the "Run" tab, and then the query results will be displayed.

Aug 20, 2019 am 09:37 AM

navicat 查询表

How to connect to database file in navicat

Open Navicat, click "Conection", and select any database in the drop-down menu. ||Enter general information and click "Test Connection". ||Right-click the database you just connected to, select "Open Connection", enter the password, and click "OK".

Aug 20, 2019 am 09:21 AM

navicat 连接数据库文件

How to download navicat

Download navicat can be downloaded from navicat's official website, but the official download has a trial period. After expiration, you need to spend money to purchase it for normal use, and it is expensive. Of course, it can also be downloaded from the PHP Chinese website, and installation and cracking tutorials are also provided.

Aug 19, 2019 pm 01:25 PM

navicat

How to export tables in navicat

Steps for exporting tables in navicat: First open navicat, select the database, click on the data table to be exported, right-click, and then select "Export Wizard". Click the sql script file (*sql) in the pop-up window and click Next. Set the save location and click Save.

Aug 19, 2019 pm 01:12 PM

navicat