Top "Navicat" questions

MySQL Views in Navicat - How to define 'primary key'?

Often when I define a View in Navicat I receive the following message: xxx does not have a primary key. …

mysql views primary-key unique-index navicat

How can i get a count(*) of all the columns in a table? Using PostgreSql

I have bunch of tables where several of them have hundreds of columns. I need to get a count of …

sql database postgresql navicat

Table relations in Navicat

How do I add table relations in Navicat without using SQL queries? Is there some kind of wizard or helper …

mysql foreign-key-relationship navicat

PostgreSQL: column "rolcatupdate" does not exist error?

I installed PostgreSQL on new server. When I try create new table or new data base, get this error: column "…

postgresql psql navicat

How can i see my created stored procedure in Navicat for MySQL

I create stored procedure in Navicat for MySQL as follow: CREATE PROCEDURE myloop() BEGIN DECLARE customerID INT DEFAULT 11; first_loop: …

mysql navicat

Navicat - lost connection to mysql server at 'reading initial communication packet', system error: 0

I am getting the error listed above when trying to connect to my MySQL server via SSH public key in …

mysql ssh navicat

Navicat can't connect mysql server via ssh

I can connect the server via ssh and login the mysql via mysql -u root -h localhost -p without any …

mysql ubuntu ssh navicat

Setting auto increment id in Postgres with Navicat

I'm rather new to Postgres and Navicat is the only fully functional GUI that I've come across. That said, I'm …

postgresql navicat

Navicat: Failed to save password Error code: -34018 on mac os

I try to use navicat on mac os Big Sur but whene I put password get this error! Failed to …

macos keychain navicat

Navicat utf8 not working on mysql database

I'm currently trying to merge data changes between two out of sync expressionengine databases. For this i have opted to …

mysql utf-8 expressionengine navicat