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

Article Tags

navicat

Home

Technical articles

Database

navicat

How to deal with 1130 in navicat

The 1130 error in navicat is because MySQL has only one root user. After changing the root password and selecting MD5, an error will be reported after logging in again after submission. Workaround: Edit my.ini. Add a sentence in the [mysqld] section: skip-grant-tables.

Aug 05, 2019 am 09:30 AM

navicat

How to establish multi-table links in Navicat for MySQL

Open navicat and create three tables, the clean_data table and the user table, as well as the relationship table between the two tables. ||Set the two fields cln_dt_id and user_id to be associated in the clean_data_user table as primary keys. ||Click the foreign key button to establish a foreign key relationship.

Aug 05, 2019 am 09:28 AM

Navicat for MySQL多表链接

How to set navicat to Chinese

Open the navicat application interface, click Tools, select Options, click Fonts, click the drop-down box, and select the required language font. Then click Save after completing the Chinese settings for other options.

Aug 05, 2019 am 09:20 AM

navicat

How to uninstall Navicat

To uninstall navicat, first go to Windows settings, select Applications, find navicat, and select uninstall. Then on my computer, find the installation directory of navicat and delete all the files in it. Finally, enter regedit in the run window, find and delete the navicat registry in the pop-up window.

Aug 05, 2019 am 09:12 AM

navicat

How to delete oracle table in navicat

The first step is to open Navicat, right-click the oracle database, and then click "Open Connection". ||The second step is to click "Others" and then click "Database Link". ||The third step is to right-click the database link you want to delete, select "Delete Database Link", check "OK", and finally click "Delete".

Aug 03, 2019 pm 04:35 PM

navicat删除oracle表

How to check mysql version in navicat

Navicat checks the mysql version. You only need to create a new query. In the new query window, execute the following sql statement select version() from dual. You can see the mysql version currently used by navicat.

Aug 03, 2019 pm 04:22 PM

navicatmysql

How to see table relationships in navicat

Open navicat, select the database you want to view, click the "View" menu, and we see that the list is selected by default. So what we see is that the data table is displayed in list form by default. We only need to click to switch to "ER Diagram" to create an ER relationship diagram.

Aug 03, 2019 pm 04:06 PM

navicat

How to install navicat

The first step is to open the Navicat installation package and install it. ||The second step is to agree to the installation license and click Next. ||The third step is to select the installation path, select the start directory, and create a desktop icon. ||The fourth step is to select "Install" and click "Finish". ||The fifth step is to enter the registration code to activate the software.

Aug 03, 2019 pm 04:01 PM

安装navicat

How to backup database in navicat

First open the navicat software, right-click the database that needs to be backed up, and select "Dump SQL File" -> "Structure and Files". Select the location for file backup in the pop-up window. Just click start.

Aug 03, 2019 pm 03:48 PM

navicat数据库

What should I do if I forget my password in navicat?

Close the running MySQL service; || Open the DOS window and go to the mysql→bin directory; || Connect to the permission database; || Change the user name to root and the password to 123; || Refresh the permissions and exit; || Log out of the system, Enter again and log in using the username root and the new password 123 you just set.

Aug 03, 2019 pm 03:47 PM

navicat忘记密码

How to build a library in navicat 8 for mysql

First start the database operating environment. Open the navicat software, right-click and select New Database. Then name the database and choose a character set and collation. Click Decide. Right-click refresh and you can see the database you just created.

Aug 03, 2019 pm 03:36 PM

navicatmysql

How to import dmp files in navicat

The first step is to use navicat to connect to the Oracle database. ||The second step is to select "Others" in the menu bar, click "Directory", and then click "Design Directory". ||The third step, click "Data Pump", then click "Data Pump Import", set the file name in the dump file to a dmp file, click "Generate", and run.

Aug 03, 2019 pm 03:32 PM

navicat导入dmp文件

How to import sql in navicat for mysql

First create a database, because the sql file only has statements to insert data. Then select utf-8 format. Double-click the newly created database, right-click and select Run sql file. Then select the sql file you need to run. Just click start.

Aug 03, 2019 pm 03:22 PM

navicatmysqlsql

How to modify data in navicat

Select the table you want to modify the data in, create a new query window, and query the table you want to modify in the query window, such as select * from tableA; then you can modify the data you want to modify on the record displayed below. Remember to enter the commit command in the query window after modification and execute it, and it will be saved successfully.

Aug 03, 2019 pm 03:14 PM

navicat修改数据