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
2 answers

I can't open HeidiSQL

I used MariaDB and HeidiSQL without error nor problems before trying import some sql dump. But When I try to import sql dump, it says about 'Out of Memory' and closed with system error message and it doesn't open. After that error, when I click…
엄태선
  • 13
  • 3
0
votes
1 answer

SQL SUM up specific rows without subquery returning more than one row

There are a few posts that seem similar to this problem, but I cannot find the solution to this problem through those posts. I have the following two tables that I am working with (I'm not posting the full table, just as much is needed to understand…
gabbagoo
  • 3
  • 3
0
votes
2 answers

How to syntactically indicate a table for altering its column in postgres sql

I am trying to alter a table by changing the datatypes of a few columns from text to integer/boolean/date When I try to execute it as alter table "TimeSeriesData" alter COLUMN "details_id" TYPE BIGINT; I get this error ERROR: column "details_id"…
Ann
  • 137
  • 1
  • 11
0
votes
1 answer

How to authenticate with Active Directory in HeidiSQL?

Anyone also using this nifty little client? https://www.heidisql.com/ It works on databases hosted on the local but it is unable to connect to the server on Azure via Active Directory. SQL Server 12.0.2000.8
k_rollo
  • 5,304
  • 16
  • 63
  • 95
0
votes
0 answers

Not being able to import table heidiSQL - Postgres

I am trying to import this sql script to my db on heidiSQL. But I get this error when I run the script ERROR: type "app_activity_date_index" does not exist LINE 9: INDEX "app_activity_date_index" ("date") The code: CREATE TABLE IF NOT EXISTS…
João Telemovel
  • 1
  • 3
0
votes
1 answer

how to use the ssl flags with heidisql's cli arguments?

HeidiSql supports CLI arguments: https://www.heidisql.com/help.php#commandline I want to use the sslcacertificate option (-sslca or --sslcacertificate) but I keep getting errors, most likely because I am not using that flag correctly. For example,…
S. ten Brinke
  • 2,557
  • 4
  • 25
  • 50
0
votes
1 answer

Show error "Not Valid Win32 application" after upgraded to Heidisql v12

Shows error "Not Valid Win32 application" after upgraded from v11 to v12. It shows there is problem on the plink.exe but it was fine configured in v11.
leo
  • 269
  • 1
  • 11
0
votes
1 answer

PostgreSQL COPY FROM issue

DROP table if exists legislators; CREATE table legislators ( ... ) ; COPY legislators FROM 'C:\data\legislators.csv' DELIMITER ',' -- It is written in different line from `FROM` clause but it raises ERROR. CSV HEADER; I am trying to import CSV…
Park
  • 2,446
  • 1
  • 16
  • 25
0
votes
1 answer

Import CSV file/Transform data with compound values in a cell

Is there a way to import a csv file or transform a table with delimited compound values? Example: CSV file has: | years | model | | -------- | -------------- | | 2019,2020,2021 | ABC | Database should end up like: | year | model | |…
Casey
  • 536
  • 2
  • 14
  • 28
0
votes
1 answer

Unable to connect to mysl container via HeidiSQL via localhost

Environment: I've created and started a Docker container on Windows 11 via the following command: docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=root -d mysql:latest Then I've created a new HeidiSQL session with the following options: library:…
devpelux
  • 2,492
  • 3
  • 18
  • 38
0
votes
1 answer

Android Studio connecting to SQL Database

I am trying to connect Android studio app to SQL server (Heidi SQL) I have the jtds jars (jtds-1.2.7.jar) file inside the lib and added the dependency. It still doesnt read the data and show the result from the database and I have this…
JJjang
  • 11
  • 1
0
votes
1 answer

HeidiSQL How to remove duplicate rows (WO#) and only keep most recent time stamp

I am a novice with using HeidiSQL and am hoping someone can help me modify my query to remove duplicate WO# keeping only the most recent date_quoted. An example of what I am looking to achieve is in the picture below, and here is my…
Carla Dawn
  • 1
0
votes
1 answer

How to save all warning in mariadb using Heidisql?

I want to save all warnings in mariadb using Heidisql. But I have few problems. If I run more than one SQL together, the latest SQL warnings will cover pervious SQL warnings. So I only can see the latest executed SQL warnings. Is it possible the…
cvh97650
  • 1
0
votes
1 answer

Return rows which contain times greater than one hour

I have this query: SELECT s.* FROM stop s WHERE s.hour> (SELECT st.hours FROM stop st JOIN City cit ON cit.id = st.idCity WHERE cit.name = 'LA' ) But the subquery returns more than one row, how should I…
gianluca23
  • 23
  • 5
0
votes
1 answer

MariaDB with Heidisql JSON_REMOVE not working

i try to execute following statement on my heidisql mariadb db: UPDATE users SET inventory=JSON_REMOVE(inventory,'$.spray'); it already worked on phpmyadmin on other databases, but not here. I get the following error: someone knows about this…
Soubi
  • 1
1 2 3
…
27 28