Top "Navicat" questions

Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT

I am fairly new to MySQL and I am getting a pretty interesting error on which I cannot find any …

mysql macos navicat tablespace

MariaDB not allowing remote connections

As the screenshots show, I have the accounts setup to allow remote connections but as shown in the second screenshot …

mysql windows windows-server-2008 mariadb navicat

Installing Navicat on Ubuntu 14.04 LTS

is there a way to install Navicat on Ubuntu 14.04 without using wine? just straight up from deb or apt-get install.. …

linux ubuntu installation wine navicat

2003 - Can't connect to MySQL server on 'localhost' (10038)

I installed mysql server in my ubuntu virtual machine, then I use Navaicat for Mysql to connet mysql, but failed. …

mysql ubuntu navicat

MySql stored procedure else if and multi queries

In the following stored procedure I encountered an error: DROP PROCEDURE IF EXISTS `SP_DeleteFileInfo`; CREATE PROCEDURE `SP_DeleteFileInfo`(pFileID …

mysql stored-procedures navicat

Install Navicat on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar …

mysql ubuntu-12.04 navicat

How to connect to sqlite database with password

I have a sqlite database and I want to connect from my C# program using a password for the database. …

c# sqlite navicat

How to get auto increment work on NAVICAT

I am using NAVICAT to make tables for MYSQL and I am unable to find the auto-increment attribute option for …

mysql primary-key increment navicat

Stop Excel from converting a string to a number

I have a column in my CSV file that contains a string of numbers separated by commas. Excel keeps converting …

excel csv navicat

SQL exclude rows matching all of multiple criteria

I currently have a query merging two tables to create a new one for analysis. After getting some funny results …

mysql sql-server where-in multiple-conditions navicat