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
0
votes
1 answer

lost connection to mysql server during query while i am trying to run a query

The error i am receiving is lost connection to mysql server during query, i am not sure why i am receiving this error im getting it while trying to run this code, my connection is fine as ive ran previous queries before this, if anyone can tell me…
Mxx1n
  • 1
0
votes
0 answers

HeidiSQL line numbers in query results window

Well...the title says it all. I'd like the query result window to show line numbers on the left edge. Is this possible in HeidiSQL Thanks!
delizat
  • 1
0
votes
0 answers

Declaring variables in HeidiSQL

Regarding HeidiSQL I would like to set a variable to the maxdate of a table in order to use this variable as a 'WHERE'-criteria in another query. I am using the following code DECLARE @maxdate timestampz SET @maxdate = (SELECT MAX("Date") FROM…
Frederik Grut
  • 11
  • 1
0
votes
0 answers

Below is a hard coded query for converting rows into column in mysql using HeidiSQL but i want a dynamic solution for conversion

SELECT CONCAT(e.c_firstName,' ',e.c_Lastname) AS NAME , sum(CASE WHEN uc.c_name='ELECTRIC CHARGES' then uc.c_amount ELSE NULL END) AS Electric, sum(CASE WHEN uc.c_name='GAS CHARGES' then uc.c_amount ELSE NULL END) AS GAS, sum(CASE WHEN…
Ahmed Akram
  • 11
  • 2
0
votes
0 answers

I have to create a query in which if any new row will be added into a table, a new column should be created in another table in mysql HeidiSQL

Bill Name Amount First row Second row third row fourth row Bill name values should be created a column in another table First Second Third if new row is added in first table, a new column should be created on…
Ahmed Akram
  • 11
  • 2
0
votes
1 answer

Importing a mMyQSL database using HeidiSQL

My MYSQL database is in .sql file format, I am trying to import it into MySQL using HeidiSQL. But, as I starting importation from the Load SQL file, the importation process is halted by this error message SQL Error (1064): You have an error in your…
Musekwa
  • 1
  • 2
0
votes
1 answer

Connecting to MariaDB/HeidiSQL instance using AWS RDS - Python

I can't seem to find the key to bring it all together for me. So I have an AWS RDS instance of a MariaDB database active. Then, upon downloading MariaDB, it actually downloaded HeidiSQL and a MySQL/MariaDB terminal to my Windows PC. I was able to…
Controlla22
  • 1
  • 1
0
votes
0 answers

Load data into Mariadb with files containing (((

I'm completely new to import CSV into MariaDB I have a CSV with the following columns that I am trying to import into a new…
mikeldub
  • 1
  • 1
0
votes
1 answer

I would like to pass data from a table with several columns to another table in a single column

good afternoon / night, let me tell you, I have a database with several tables and one of them is obsolete since I am trying to pass it to another. I put you in situation. I have the user_accounts table with the following format. "image below" I…
Wolf
  • 13
  • 4
0
votes
1 answer

How to sort a table by the count of it column?

I have this table: CREATE TABLE Publications ( publicationId INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (publicationId), title VARCHAR(60) NOT NULL UNIQUE, professorId INT NOT NULL, autors INT NOT NULL, magazine VARCHAR(60) NOT NULL, …
JBG
  • 3
  • 2
0
votes
2 answers

MySQL Stored Procedure execution takes a long time

I am trying to insert rows into a db table through a stored procedure. My table contains more than 500000 rows so when I execute the procedure, it takes more than 4h executing. Knowing that I am using Xampp server, MySQL as database management…
mypeeka
  • 57
  • 2
  • 11
0
votes
1 answer

Qt - problems with query

I have a problem with a query used with MariaDB in Qt program. I state that all other queries in the program work fine. This is the code that generates and execute the query: QSqlQuery Query; Query.prepare("SELECT d.*, dv.*, me.Descrizione…
Stefano
  • 23
  • 4
0
votes
0 answers

I can't seem to get my HeidiSQL server to run

Ok so I'm trying to make a server for RPG Maker XP using MySQL, Ruby, and HeidiSQL. I'm following this setup guide and I've run into an issue where my Ruby crashes as it opens. I've screenshotted every step I've taken past the installations of the…
whyte
  • 1
  • 1
0
votes
0 answers

Azure Database connect through OpenTextSocket proxy client in heidisql DB connector tool is works, but from java code its not works

Azure Database connect through OpenTextSocket proxy client in heidisql DB connector tool is works, but from java code its not works, Spring boot application connection with database Screenshot : address : hostXXXX/1.0.0.1 And HeidiSQl tool is using…
Raj Kumar
  • 43
  • 1
  • 5
0
votes
0 answers

I keep getting SQL Error (1064) for my AFTER INSERT Trigger

I'm using Heidi SQL and I keep getting this error. I want to create a trigger to update the attributes of the project table with those inserted into the histproject table AFTER INSERT. Here's the code: DROP TRIGGER IF EXISTS…
tae923
  • 1
1 2 3
…
27 28