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

Can not edit data in a table in MySQL

I've got a database with several tables in MySQL. All of the tables are editable using workbench and HeidiSQL, except one. I used HeidiSQL to import a CSV file into a new table called spissues. When I select * from that table, the option to edit…
user2021539
  • 949
  • 3
  • 14
  • 31
1
vote
1 answer

HeidiSQL has changed foreign keys and phpMyAdmin cannot see them

I am using HeidiSQL because I find it much easier to build in than PMA but PMA has a nice basic diagramming tool. I had a DB that was called test2. I wanted to rename it or ideally clone it. Sadly could not see how to make a copy in Heidi but could…
BeNice
  • 2,165
  • 2
  • 23
  • 38
1
vote
3 answers

SQL Server 2014 Express on Windows 10

I've downloaded and installed SQL Server 2014 Express on Windows 10, I've been through this loop at least 3 times now. The installation completes without warnings or errors. I have chosen to use Window authentication. I'm trying to use HeidiSQL to…
SPlatten
  • 5,334
  • 11
  • 57
  • 128
1
vote
2 answers

mySQL select from different rows same table

Suppose I have the following table: | ID | col1_fix | col2 | col3 | ref_ID 1 val1 val12 val13 2 val2 val22 val23 1 3 val3 val32 val33 What statement…
blues
  • 167
  • 1
  • 7
1
vote
1 answer

SQL trigger won't execute

The following trigger won't execute in HeidiSQL or phymyadmin, any assistance would be gretly appreciated in fixing. I'm using heidisql, and they used workbench. though this shouldn't matter DELIMITER $$ CREATE TRIGGER t_l_in_a BEFORE UPDATE ON…
Martin
  • 795
  • 1
  • 12
  • 31
1
vote
2 answers

Creating a very specific column in HeidiSQL

I've been trying to set up a small database with HeidiSQL but I've stumbled across a problem. I want to add in a column in a certain table that counts the amount of columns in another table containing a certain value. I've tried it by setting a…
Ciphra
  • 269
  • 2
  • 17
1
vote
2 answers

Query works in HeidiSQL but fails in C#

The below Query works in HeidiSQL but gives me an error when trying to use it in C# SELECT title.id,title.title,title.production_year,movie_info.info FROM title NATURAL JOIN movie_info WHERE title.id <= 1000; It tells me the following: I use the…
OmniOwl
  • 5,477
  • 17
  • 67
  • 116
1
vote
1 answer

SSRS Report with SQL

So I have a report that I'm trying to create for my class. I'm using the AdventureWorks database so it isn't anything to complex. I enter my SQL script in SQL Server Management Studio and HeidiSQL and both bring back the results I'm looking for, so…
Reuben deVries
  • 127
  • 1
  • 7
1
vote
2 answers

Left outer join on 2 columns not running properly

a is a table of 5,000,000 records and a score. b is a table of 100,000 records and a (different) score. I want to output every record from table a as long as the same record is not in table b with a score equal to 1. The following query I wrote has…
Mitchell
  • 169
  • 1
  • 14
1
vote
0 answers

SQL ORDER BY one column then another

So I'm joining two tables together and then I'm trying to order first by PID and then within PID order by Month. I can manage to get the query working and ordering by PID but when I try to order by month as well the query keeps running out of…
Mitchell
  • 169
  • 1
  • 14
1
vote
1 answer

my local mysql will not connect unless my computer is connected to wireless network

I have had a WAMP setup on my winXP laptop for many years with no problems. But about 2 months ago I installed SiteKiosk (kiosk software that creates a 'shell' around the OS) on my laptop. Afterwards my HeidiSQL software quit working: sql error…
dsdsdsdsd
  • 2,880
  • 6
  • 41
  • 56
1
vote
1 answer

In SQL, I need to turn my data horizontal from vertical

I have simple tables of data where event times are assoictaed to an id. Each id can have 0, 1 or more event times. So my data looks like this ID EventTime ---------- 1 15 3 49 3 78 5 68 6 62 7 85 7 86 I would like to a turn my data side…
John
  • 29
  • 5
1
vote
1 answer

MySQL not connecting with Command Prompt

I have one instance of mysql. It is running at "C:\Program Files\MySQL\MySQL Server 5.5\bin\" Now, when I try to connect using "heidisql" tool using user name as "root" and password as "eagle" then it connects properly and show the databases which I…
Jayesh
  • 6,047
  • 13
  • 49
  • 81
1
vote
0 answers

MySQL error 2013 with Heidisql but not with mysql workbench

I can't connect to a given database with mysql command line nor heidisql but this is working with mysql workbench. SQL Error (2013) in statement #0: Lost connection to MySQL server at 'waiting for initial communication packet', system error:…
Frederic Close
  • 9,389
  • 6
  • 56
  • 67
1
vote
2 answers

SQL list columns that contains '1' by given row

My app reads txt files created by the user, and containing the query text, description, input and output, type of query etc. So I can't just make it easier getting data from the DB and elaborate them in java (which I'm more advanced in). I have a…
Dani
  • 35
  • 6
1 2 3
…
27 28