table1 is the parent table with a column ID and table2 has a column IDFromTable1. Why when I put a FK on IDFromTable1 to ID in table1 do I get Foreign key constraint is incorrectly formed error? (I...

I have been trying to connect to a localdb instance with the latest version (at this time) of heidisql to no avail. I have followed the instructions from this answer here but it doesn't seem to wo...

I'm using HeidiSQL to edit a MYSQL database, and it's asking which library I want to use for the edits: libmysql-6.1.dll libmysql.dll How do I know which one to use?

I have a table which contains many fields. I'd like to set "id" and "userId" as a composite primary key in HeidiSQL, do you know if it is possible with this software?

My postgres yaml part looking like this: postgres: container_name: 'postgres' image: postgres:10.1 environment: - POSTGRES_USER=postgres - POSTGRES_PASSWORD=root - POSTGRES_DB=myids ports: ...

create table users (id int not null auto_increment , username varchar(255) NOT NULL , password varchar(255) NOT NULL , active int NOT NULL , PRIMARY KEY (id)) ENGINE=InnoDB COLLATE=utf8_unicode_ci;...

Im using mariadb with heidisql to execute sql: DECLARE @AccountID INT; Insert Into accounts(first_name, mi, last_name, email, is_admin, is_enabled, date_created) Values('testfirstname', 'a', 'tes...

Just like title say. I am using HeidiSQL, and i wan't to duplicate a database so i export the database, create a new empty with name "test". Then i change the name of the database to "test" in the ...

I'm using a stored procedure in a Spring Boot project and trying to get an output value, but in my project it always returns null. But if I'm calling the procedure through HeidiSQL it works and giv...

I've been trying to add a foreign key to my table using heidisql and I keep getting the error 1452. After reading around I made sure all my tables were running on InnoDB as well as checking that t...

i have a table with 3 generic keys which are also foreign keys. This is my query -- IF (EXISTS(SELECT * FROM table1 WHERE col_1 =4)) BEGIN UPDATE table1 SET col_2 = 3, col_3 = 100 WHERE co...

I have declared a variable in a heidisql tab like this DECLARE total_count INT DEFAULT 0; SET total_count = 10; select total_count; but i get this error /* SQL Error (1064): You have an error...

I don't know if this is a user error on my end, or if the remote server is configured incorrectly. I was given some connection info for a server as follows: Server IP server username keyfile ...

I have a local installation of MariaDB on a Windows XP. I created an empty database db_y which I wanted to populate with the tables of the database db_x which I exported as a dump-file from a MySQL...

I want to import a csv file to my MySQL database with HeidiSQL. But some of my fields are empty. What could I do to let HeidiSQL know these empty values have to be seen as NULL-values? Sample of...