Top "Heidisql" questions

HeidiSQL is a lightweight, Windows based application for managing MySQL, MariaDB, MS SQL, PostgreSQL and SQLite databases.

mysql Foreign key constraint is incorrectly formed error

I have two tables, table1 is the parent table with a column ID and table2 with a column IDFromTable1 (not …

mysql sql heidisql
Database Import error after exporting

Just like title say. I am using HeidiSQL, and i wan't to duplicate a database so i export the database, …

mysql database import heidisql
How to copy a database using HeidiSQL?

I have a local installation of MariaDB on a Windows XP. I created an empty database db_y which I …

mysql database heidisql
How to create table in MariaDB?

When I try to create simple table via HeidiSQL I'm getting an error like this CREATE TABLE `prg_config` ( `id` …

mysql sql mariadb heidisql
sql if exists update else insert not working

i have a table with 3 generic keys which are also foreign keys. This is my query -- IF (EXISTS(SELECT * …

mysql sql if-statement exists heidisql
mariadb declare variable syntax error

Im using mariadb with heidisql to execute sql: DECLARE @AccountID INT; Insert Into accounts(first_name, mi, last_name, email, …

sql mariadb heidisql
generate sql using HeidiSQL

I would like to ask is there any config that allow HeidiSQL to generate INSERT query that look like: INSERT …

mysql sql heidisql
MySQL Indexing, Different types and when to use them?

Ok, So I have (re)searched a lot regarding MySQL Indexes and their importance and I understand i have to …

mysql database indexing relational-database heidisql
SQL Server AUTO_INCREMENT error

Interface: HeidiSQL Database: SQL Server I'm trying to create table keeping ID (int) column as primary key as well as …

database sql-server-2008 primary-key auto-increment heidisql
Importing SQL file to HeidiSQL

When I try to import the table and datas to HeidiSQL, I am getting two kind of errors. When Load …

mysql heidisql