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

Connecting to SQL Server with HeidiSQL

I am using Windows 10 64bit. I installed SQL Server 2014 Express. The SQL Server service is running. Now I am trying to connect to the running SQL Server with HeidiSQL. I am using SQL Server named pipes and it is not working. Can you please help me…
Ramasamy Viswanathan
  • 25
  • 6
1
vote
0 answers

MySQL / HeidiSQL - affected rows in log is 0 but rows have definitely been affected

I'm updating a a large number of rows (~168k) with an UPDATE query that contains various JOINS. (i changed the field and table names, but the logic of the query stays the same) UPDATE table_a JOIN table_b on table_a.field1 = table_b=field1 JOIN…
Florian Graf
  • 11
  • 1
1
vote
0 answers

Cannot load data from text file to MySQL table

I have a text file with millions of rows. Example: sorage.txt foo bar baz File was loaded as follows: LOAD DATA INFILE '/var/lib/mysql-files/sorage.txt' INTO TABLE `storage` (@word) SET col1 = @word, col2 = CONCAT('prefix_', @word) Afterwards I…
Jekis
  • 4,274
  • 2
  • 36
  • 42
1
vote
2 answers

Run .sql file with Inno Setup

I am trying to run .sql file using Inno Setup. [Run] Filename: "C:\Program Files\HeidiSQL\heidisql.exe"; \ Parameters: "-u root -p Password -h localhost --execute=""G20 Standard.sql"""; \ WorkingDir: {app}; StatusMsg: Loading Database;…
Ruoks
  • 13
  • 4
1
vote
1 answer

I can not add 'č' 'ř' 'ě'

I use HeidiSQL. I am unable add to my database characters with diacritics such as č, ř or ě. For example, when I try add a character č, the following error occurs: Incorrect string value: '\xC4\x8D\' for column 'name' at row 1. What I can do?…
Jirka Luňák
  • 19
  • 6
1
vote
1 answer

Stored Procedure does not update the table for MySQL

Running this routine on HeidiSQL and it runs with 0 rows affected, even though there should be exactly 1 row affected. both select statements seem to work fine outside this Stored Procedure. BEGIN DECLARE someId INT; DECLARE done INT DEFAULT…
madkimchi
  • 77
  • 1
  • 7
1
vote
1 answer

How can solve duplicate values in sql

How can i write this sql queries? Results have same values, i want to see below Hotspot_Adi | Referans_Numarasi | Il | Bolge | CA | ADETI | KYS | ADET A | xxxx | y | z | AP | 2 | AP | 2 A …
Mnks
  • 9
  • 3
1
vote
2 answers

MariaDB incorrect syntax near ''

as the title says, I have an error with my syntax somewhere. This is MariaDB 10.1.31. DROP FUNCTION IF EXISTS NO_UMLAUT; CREATE FUNCTION NO_UMLAUT(TextString VARCHAR(255)) RETURNS VARCHAR(255) BEGIN SET TextString = REPLACE(TextString, 'ä',…
shaelex
  • 251
  • 3
  • 17
1
vote
1 answer

Newbie in dilemma due to OCD tries to reorder SQL database automatically

Sorry, I'm very new to SQL. I just learned it few hours ago. I'm using MariaDB + InnoDB Engine with HeidiSQL software + CodeIgniter 3. Let's say I have a table named disciples with the following data: ------------------- | sort_id | name | …
Rangka Kacang
  • 327
  • 1
  • 5
  • 12
1
vote
0 answers

HeidiSQL different SQL result on Windows XP (SP2)

I'm doing application development on VB.net. calculated date field was not display on screen. Testing directly on heidisql returned null value on Windows XP. I know the OS was not supported, but we have certain legacy app that need to run on XP.…
syahman
  • 35
  • 2
  • 7
1
vote
1 answer

JOIN performance very slow when selecting VARCHAR field

I have a difficult problem with a query which I can't find out why it is performing so bad. Please see following queries and query times (using HeidiSQL): SELECT p.TID, a.TID FROM characters AS p JOIN account a ON p.AccountId = a.TID; => rows:…
BlueM
  • 6,523
  • 1
  • 25
  • 30
1
vote
2 answers

How to connect to laravel forge database via SSH tunnel using HeidiSQL

I'm trying to do the above. HeidiSQL has a load of settings and I have a load of possible values, but I'm not sure exactly what goes where. Here are the different places I can put values Settings screen SSH screen And the values I have are as…
NYoung
  • 157
  • 1
  • 14
1
vote
2 answers

How can i select combine category name in my SQL select statement?

I have a select statement as below: SELECT sales.Added_by as "Added_By", CONCAT(HOUR(sales.Sales_Date), ':00-', HOUR(sales.Sales_Date)+2, ':00') AS Hours, COUNT(sales.Sales_ID) AS `Sales_ID`, sum(sales.Quantity) as "Quantity", …
Test 87
  • 101
  • 2
  • 10
1
vote
1 answer

Unable to ssh into database with heidisql

Configuration I am using: Network type : SSH Tunnel Hostname : 127.0.0.1 User : *Database Username* Password : *Database Password* SSH Host : Server IP Port : 22 Username : *Username* Private key file : .ssh/id_rsa Error I am getting: PLink exited…
Ruben
  • 500
  • 7
  • 16
1
vote
1 answer

How to change HeidiSQL completion shortcut?

My native language is not English, and on my system, the ctrl-space key binding is used for switching input method. While in HeidiSQL, this key binding is used for SQL code completion. Is it possible to rebind this function to another key, say,…
Nick
  • 8,451
  • 13
  • 57
  • 106
1 2 3
…
27 28