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
1
vote
1 answer

Cannot execute huge sql file

A friend of mine made a backup via HeidiSQL 4, a really outdated one. The database got deleted, and now that's my only savior. So the instead of backticks(`), HeidiSQL uses quotes(") when it comes to tables. Tried to replace all of the quotes with…
bobzrz8
  • 129
  • 1
  • 3
  • 12
1
vote
1 answer

SQL Load data concurrent infile

I am trying to run this query LOAD DATA CONCURRENT INFILE 'C:\\Data-API.csv' INTO TABLE pbp_person FIELDS TERMINATED BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (email, first_name, last_name, title, company_name, address, city,…
user979331
  • 11,039
  • 73
  • 223
  • 418
0
votes
1 answer

Table doesn't / does exist in engine

Lot's of threads, but couldn't find one that fits. I am new at all this. I had to downgrade from MariaDB 10.11 to 10.6 on Windows for reasons with IIS. So just uninstalled 10.11 and started with new Data folder. Copied in some small tables with a…
Bill Parker
  • 3
  • 1
0
votes
0 answers

How do you take commas out of integers in HeidiSQL?

In HeidiSQL, integers display with commas; I'd like numbers to display with no commas. Old posts on this say to go to Tools > Preferences > Text Formatting > "Local Number Format", but in the newest version of HeidiSQL (12.5.0.6677) there is no…
Cmaso
  • 1,095
  • 1
  • 10
  • 23
0
votes
0 answers

HeidiSQL doesn't see PostgreSQL datebases

could anyone explain why my HeidiSQL doesn't see created datebases with postgres? To connect I've choose this settings: Network Type: PostgreSQL (TCP/IP) Library: libpq-10.dll Host Name: localhost User: postgres Pass: the same as from install Port:…
ais
  • 11
  • 2
0
votes
1 answer

SQL_MODE is not being changed

I have the latest mysql version, also i'm using HeidiSQL. I've edited my.ini [mysqld] sql_mode = '' I've restarted the mysql server and when I query SELECT @@GLOBAL.sql_mode; I get again…
Galbert
  • 177
  • 1
  • 8
0
votes
2 answers

MySQL ERROR 1045 (28000): Access denied for user

I want to connect to a readonly MySQL-DB to my Django WebAPP. Using Django, MySQL-Workbench or MySQL-Shell always resulted in the same error: ERROR 1045 (28000): Access denied for user 'db-foo-read'@'125.67.891.26' (using password: YES) I was able…
Samuel Grosser
  • 23
  • 6
0
votes
2 answers

Unity HeidiSQL Connection Authentication method 'auth_gssapi_client' not supported

I am trying to connect my Unity multiplayer game with my MariaDB but i get the ERROR: MySqlException: Authentication method 'auth_gssapi_client' not supported by any of the available plugins. MySql.Data.MySqlClient.NativeDriver.Open () (at…
Dru.Dru
  • 59
  • 7
0
votes
1 answer

Unity HeidiSQL Connection timed out

In my Unity project i have a MariaDB and HeidiSQL as the interface. I now want to connect my unity script with that database and make queries. In my Database.cs i have following code: using System.Collections; using System.Collections.Generic; using…
Dru.Dru
  • 59
  • 7
0
votes
1 answer

C# MVC Web application SQL not working properly

Currently I am facing issue in my web application. Background > This web application is working well for 4 to 5 years Recently, I receive the error message return as below. (Noted: My Code never changes since 2 to 3 years ago) Unknown column '''…
Ng Zheng
  • 59
  • 1
  • 12
0
votes
2 answers

SQL: GROUP BY column B for groups in column a

I am looking for a SQL query that will sum the values in column C GROUP BY column B, but not over the entire table, only within the ranges where the same values are present in column A. Current table: Column A Column B Column…
testuser181920
  • 3
  • 1
0
votes
0 answers

I want to know the jobcount between 6 AM to 6 AM of the next day of a selected day MARIA DB(Heidi sql 11.3)

have got a task to take the jobcount between 6 am to next 6 am of the day. for example if i need yesterdays jobcount it should be calculated from yesterday's 6 am to today's 6 am. SELECT DATE(`panel_end` - interval (6*60) MINUTE) AS dt, COUNT(*) AS…
Sachin ganeshkar
  • 1
0
votes
0 answers

How to Access Remote PostgreSQL Database Server Through VPN

I'm currently working with my office server, when i want to connect to the server, i have to use their VPN. I have installed PostgreSQL database in their server and have succesfully migrate data to database from Django project. But, when i want to…
Michael Halim
  • 262
  • 2
  • 20
0
votes
0 answers

Is there an option to import a csv with unequal amount of columns per row and split according to name?

CSV table with unequal columns per row Is there an option to import a csv with unequal columns per row? What I would like to have is to fit "Classnr_Class_ptsclass_ptsratioclass_meandistDensity" into a separate table linked with the classnr (Primary…
Zurch
  • 1
  • 1
0
votes
1 answer

MariaDB multiple update queries takes too much time on certain computer and takes way less time on all other computers

We use MariaDB database on our projects. I observed program was working slowly on my machine. I made some test using Heidisql. Updating 2000 row un my machine takes 9 second. But when I open virtual machine in my computer and run same query it takes…
Kivannc
  • 106
  • 8
1 2 3
…
27 28