Page 57-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

The relationship between Navicat and SQL

Navicat is a set of database management tools; SQL is a structured query language, which is the standard language for relational database management systems; and SQL Server is a relational database management system; then Navicat can be used to run local or remote SQL Server databases Carry out management and development.

Aug 26, 2019 pm 01:34 PM

Navicat SQL

What are navicat table field annotations?

Navicat table field annotations are explanations and descriptions of the fields. Their purpose is to make it easier for people to understand the fields and make it more intuitive when viewing the table.

Aug 23, 2019 pm 02:29 PM

navicat

How to use navicat to create a new table

Open Navicat, open the mysql database connection, and select the database where the new table is located, such as newdb, right-click, select [Open Database], and click [New Table] under the object bar; in the new table interface, set the fields and fill in the table name, click [Confirm];

Aug 23, 2019 pm 02:13 PM

navicat

How to check which tables are there in navicat

There are two ways to check the tables in the database in navicat: 1. Click [ER Diagram] in the lower right corner of navicat. All tables in the database are displayed in the ER diagram. 2. Click on the table in the database to view which tables there are.

Aug 23, 2019 pm 01:58 PM

navicat

How to establish connection with navicat 10038 error

This error is usually caused by the mysql service not being started. [win+R]->cmd->services.msc->Enter, open the service, find mysql, start it, go back to Navicat for MySQL and click on the existing connection. This time you can see that it can be opened normally.

Aug 23, 2019 pm 01:45 PM

navicat

How to add columns in navicat

Open navicat, open the connection, open the database, select the table, right-click and select [Design Table]; enter the design table interface, click [Add Field], and set it; click [Open Table], refresh it, and you will find that it has been There is one more column, which is the field just added.

Aug 23, 2019 pm 01:24 PM

navicat

How to import dmp in navicat

Click [Others] to create a [Directory] and place the .dmp file in this directory. Click [Data Pump] - [Data Pump Import] above to add the configuration to the created directory.

Aug 23, 2019 pm 01:11 PM

navicat

How to connect to navicat for mysql

Connection method: 1. Click "Connect" in the toolbar, select "MySQL" to enter the connection setting interface; 2. Fill in the "Connection Name", "Host Name or IP Address", "Port", and "Settings" set when installing MySQL. Username", "Password", click "OK"; 3. Double-click MySQL in the "Management Area" to connect.

Aug 23, 2019 am 11:48 AM

navicat

How to check the character set of a table in navicat

Open navicat, open the connection, open the database, select the table, right-click and select [Design Table]; click [Options] in the design table window; you can view the [Character Set] of the table in the options interface.

Aug 23, 2019 am 11:21 AM

navicat

How to view sql statements in navicat

Right-click the table you want to view in the database and select [Object Information]; click [DDL] to view the SQL statement of this table.

Aug 23, 2019 am 11:02 AM

navicat

How to export navigation database table

Open Navicat, right-click the mouse on the data we want to export, then click [Dump SQL File] on the pop-up shortcut menu, and select the first [Data and Structure] in the submenu item that pops up again. Select the save location in the pop-up box. After selecting the location, click OK, and the database table will be exported to the specified location.

Aug 23, 2019 am 10:56 AM

navicate

How to open query in navicat

Click the [Query] button on the main interface of Navicat to open the query object list. Or click the [New Query] button in the main window to open the query creation tool or query editor. You can also click [Open Query] to view it.

Aug 23, 2019 am 10:40 AM

navicat

How to use sql statement in navicat

First, write the correct SQL statement in Navicat's [Query Editor]; then click the [Run] button to use the SQL statement. Then such an "impact" message will pop up to indicate whether the execution was successful or failed.

Aug 23, 2019 am 10:30 AM

navicat

How to import mysql database in navicat

In the mysql connection, create a new database. The name of the database must be consistent with the imported mysql database file. Right-click the newly created database and select [Run SQL File...]; click "..." to select the path where the mysql database file is located, and click [Start] to import the mysql database.

Aug 23, 2019 am 10:16 AM

navicat