Stack Overflow
Stack Overflow

Questions tagged [heidisql]

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

Overview

HeidiSQL is a useful and reliable tool designed for web developers using the popular MariaDB and MySQL server, Microsoft SQL databases, PostgreSQL and SQLite. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.

ScreenShot

enter image description here

Links

Official website
HeidiSQL on Github

408 questions
5
votes
2 answers

Declaring mysql variables inside a heidisql query tab

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 in your SQL syntax; check the manual that corresponds…
user3286430
5
votes
1 answer

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 use it to make database queries run faster., And i know the syntax to add index on any filed. But here's what i don't understand, ( I am using…
Dhruv Kumar Jha
  • 6,421
  • 8
  • 37
  • 48
5
votes
3 answers

HeidiSQL connecting to mysql server - Lost connection...server at reading initial

New to connecting to databases and have no clue to where to begin to troubleshoot - I am currently using HeidiSQL to connect to an external Mysql Database Server hosted on the Amazon Web Service - EC2. I am able to access the database using…
user1639926
  • 852
  • 2
  • 11
  • 21
4
votes
1 answer

How to securely store HeidiSQL passwords

According to this HeidiSQL stores passwords obfuscated in the registry. I would like to save them in a more secure manner: I have an encrypted VeraCrypt volume and I want HeidiSQL to only access my passwords when the volume is mounted. Is there a…
Tim Pohlmann
  • 4,140
  • 3
  • 32
  • 61
4
votes
3 answers

How do I create a stored procedure in heidisql?

I'm trying to create a stored procedure in heidisql (mysql). CREATE PROCEDURE SP_FORM20_POST( P_SESSIONID VARCHAR(256) ) BEGIN INSERT INTO tbForm20 ( SESSIONID, RegDT) VALUES ( P_SESSIONID, NOW()); END This is my…
HanTael
  • 97
  • 1
  • 3
  • 8
4
votes
2 answers

Incorrect syntax near a var

I'm working with HeidiSQL on SQL Server, trying to create an after insert trigger, here is the code. CREATE TRIGGER TR_After_Insert_User ON User1 AFTER INSERT AS BEGIN declare @userName varchar(24) declare @userLName varchar(20) declare…
AleOtero93
  • 473
  • 12
  • 32
4
votes
2 answers

generate sql using HeidiSQL

I would like to ask is there any config that allow HeidiSQL to generate INSERT query that look like: INSERT INTO state SET ST_ID = NULL, ST_NAME = "lol" instead of: INSERT INTO state (ST_ID, ST_NAME) VALUES (NULL, 'lol')
Syafiq Azwan
  • 178
  • 1
  • 2
  • 10
3
votes
0 answers

Referenced table not found in the data dictionary mariadb

so I have written this Mariadb code as the solution for an assignment and am running it on HeidiSQL. It should work in theory however I am getting the error message SQL Error (1005): Can't create table bestellung.arbeitetin (errno: 150 "Foreign key…
Sasha Krivenko
  • 31
  • 2
3
votes
0 answers

Exporting database connections from MySQL Workbench into HeidiSql

Has anyone successfully exported their db connections from MySQL Workbench into HeidiSql? Workbench's export gives me XML files (tools>config>backup connections) but apparently HeidiSql expects a .txt file to import. Are the two just simply not…
Alex Russell
  • 172
  • 1
  • 13
3
votes
1 answer

Error "is not BASE TABLE" on repairing corrupted table

One of my tables got corrupted, so, in order to correct, I used the interface of HeidiSql. The problem is that during the process of repair, my connection to the internet was losted, and now the HeidiSQL throws me the error "is not BASE TABLE" if I…
Luis
  • 31
  • 1
  • 3
3
votes
1 answer

How do I find and replace in a CSV I'm importing using mysql

I'm importing a CSV file into Heidi SQL. I've created the table using this code: create table all_data ( Keyword varchar(1000), Position int, Previous_Position int, Search_Volume int, KW_Difficulty float, …
jceg316
  • 469
  • 1
  • 9
  • 17
3
votes
2 answers

How to use select Case in the following SQL query

I have two tables users and userdetail. I am trying to create a view in which if status of userdetail column is 1 it should show Active in view and blocked if status is 0: CREATE VIEW `new` AS SELECT users.id AS id, userdetail.healthissues AS…
shreyas pimpalkar
  • 55
  • 4
3
votes
2 answers

Access MySQL server remotely

I install mysql manually by sshing the virtual disk of google compute engine . I already create user by following this mysql-adding-user-for-remote-access and I bind address = 0.0.0.0 then restart mysql service, when I connect remotely using…
jemz
  • 4,987
  • 18
  • 62
  • 102
3
votes
3 answers

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` INT NULL AUTO_INCREMENT, `name` VARCHAR(50) NULL DEFAULT '', `value` VARCHAR NULL DEFAULT '' ) COLLATE='utf8_bin';
user1564141
  • 5,911
  • 5
  • 21
  • 18
3
votes
2 answers

HeidiSQL - How to Select Individual Columns Explicitly into Query Window?

Apologies if title is unclear, couldn't think of a concise way to express this. I'm wondering if HeidiSQL has some simple functionality to quickly create a new select query which explicitly lists every column contained in that table. In MS SQL…
user3198428
  • 31
  • 1
  • 3
1
2
3
…
27 28