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

Article Tags

navicat

Home

Technical articles

Database

navicat

How to delete data in navicat

The first step is to open Navicat, connect to the mysql client, and find the data to be deleted. ||The second step is to select the data to be deleted, which can be single or multiple. ||The third step is to right-click the selected data and select "Delete Record".

Aug 05, 2019 am 11:34 AM

t删除navica数据

How to create a stored procedure in navicat

Steps for navicat to create a stored procedure: Open navicat, select database, select function, and create a new function. selection process. Write stored procedure code as needed. Save and enter the stored procedure name and click OK.

Aug 05, 2019 am 11:33 AM

navicat存储过程

How to solve navicat garbled characters

When installing Navicat on the ubuntu system, garbled boxes appear: first find the start_navicat file in the software installation directory, then enter nano start_navicat, the file content will be displayed, change the encoding format to zh_CN, then Ctrl X, Y, and finally press Enter to solve the problem .

Aug 05, 2019 am 11:23 AM

navicat乱码解决

How to create a user in navicat

Steps to create a user in navicat: First open navicat and select the database where you want to create a user. Click to create a new user and set user information. Click Server Permissions to set the user's permissions. Finally click save.

Aug 05, 2019 am 11:08 AM

navicat

How to generate er diagram in navicat

The first step is to open Navicat and connect to the database. ||The second step is to select "View" in the menu bar. ||The third step is to select the ER diagram in the drop-down menu of View to generate the ER diagram.

Aug 05, 2019 am 11:05 AM

navicat生成er图

How to configure Navicat

The first step is to open Navicat and click "Connect". ||The second step is to open the connection drop-down menu and select a database, such as MySQL. ||The third step is to enter the MySQL new connection page and enter the connection name, host, port number, user name, password and other information.

Aug 05, 2019 am 10:53 AM

Navicat配置

How to create a view in navicat

Open navicat, select the database you want to operate, click the view icon, and create a new view. Views can be created here through SQL statements or using Navicat's view creation tool.

Aug 05, 2019 am 10:50 AM

navicat视图

How to add foreign keys in navicat

The first step is to open Navicat and create a table. ||The second step is to open the table design interface and click "Foreign Key". ||The third step is to set the custom name, field, reference database, reference table, reference field, deletion time and update time in the foreign key setting interface.

Aug 05, 2019 am 10:41 AM

navicat添加外键

What should I do if the new query system of Navicat cannot find the specified path?

The first step is to close the database connection. ||The second step is to select the connection, right-click "Edit Connection". ||The third step is to select "Advanced" and change the default path in the setting location to the Navicat directory path. ||After the settings are completed, click "Query", then select "New Query" and enter SQL to test.

Aug 05, 2019 am 10:26 AM

navicat新建查询系统找不到指定路径

How to set foreign keys in navicat

Navicat foreign key setting steps: 1. Open navicat, select the database to be used, and then select the data table. 2. Right-click the design table. 3. Select the foreign key in the design window. Here you can set the name of the foreign key, the related table associated with the foreign key, related fields, etc. After setting, just save and exit.

Aug 05, 2019 am 10:21 AM

navicat外键

How to export sql statement in navicat

The first step is to open Navicat and connect to the database. ||The second step is to create a table and insert data. ||The third step is to enter the query statement. ||The fourth step, click "Save As", enter the query name, click "OK" to export, click "test", right-click to open the included folder, and you can view the saved sql file.

Aug 05, 2019 am 10:10 AM

navicat导出sql语句

How to check the version in navicat

Navicat has two ways to check the version. The first one is to click Help on the Navicat page, select About, and you can check the version information in the pop-up window. Second, find the installation directory of navicat, find the navicat application, right-click on properties, and you can view the version information of navicat.

Aug 05, 2019 am 10:03 AM

navicat

How to create a trigger in Navicat

Navicat trigger creation steps: First open Navicat, select the database, select the data table, right-click to design the data table, on the design page, click the trigger label, enter the trigger name, select the trigger condition, and then enter the SQL to be executed when the trigger is triggered below statement. Finally click save.

Aug 05, 2019 am 09:48 AM

navicat

How to import tables in Navicat

The first step is to open Navicat and connect to the local database. ||The second step is to create a new database in the local database to store the imported sql file, and set the encoding and sorting rules. ||The third step is to open the newly created database, right-click and select "Run SQL File", then select the data file, and finally click "Start" to start importing.

Aug 05, 2019 am 09:47 AM

Navicat导入表