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

How do you make a field unique from within HeidiSQL

I'm new to HeidiSQL and can't seem to find a manual. How can I make a field unique from inside the client? I see this post here describing the SQL statement that I need. Is there a way to do this in the client with a check mark or something? Is it…
mitch
  • 396
  • 1
  • 7
  • 14
3
votes
1 answer

Date Difference in MySQL in Minutes

I need to find the time difference in Hours for the following Dates in MySQL - Can i use Datediff functions? 2014-01-01 07:27:21 and 2014-02-01 11:29:00 I tried using DATEDIFF(MINUTE,'2014-01-01 07:27:21','2014-01-01 11:29:00') but apparently MySQL…
Alankar
  • 197
  • 1
  • 3
  • 9
3
votes
1 answer

How to connect to remote mysql using sqlyoug or heidisql

I have mysql installed in unix box i want to connect that using sqlyog. Usually i can connect through putty as below. login as : root root@IP's password:: xxxxx [root@somealiasname ~] mysql -u root -p Enter password : mysql> How to Connect this…
Azhar
  • 933
  • 1
  • 12
  • 28
2
votes
2 answers

How to display arabic correctly in Spring JSF MySQL application?

i am using spring 3, JSF 2 , MYSQL, Hibernate, and Heidi SQL is the GUI tool for the database and i am having an encoding problem with Arabic characters is that Arabic words is inserted in the database as ?????????? and appears in the view in the…
Mahmoud Saleh
  • 33,303
  • 119
  • 337
  • 498
2
votes
1 answer

How can i export a mysql table which contains approximately 4-5 billions of data?

I have a MySQL database which have several tables that contains billions of data. This is the reason why I'm facing loading time problem while working on local server with live database. So I've decided to shift them on local server separately. I'm…
Mehraab Hossain
  • 68
  • 6
2
votes
0 answers

Having trouble adding a foreign key in HeidiSQL (Error 1215)

I've tried just about everything but I'm getting error 1215 when trying to create a foreign key in a child table I have. Here are my tables: CREATE TABLE `Con` ( `ConID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(250) COLLATE…
SageLeader
  • 21
  • 1
2
votes
1 answer

Postgres alter table defaults to 'NULL::character varying' instead of NULL

I am using psql to alter a database table. Currently running the following alter-statement: ALTER TABLE "devices" ADD "device_id" VARCHAR(255) NULL DEFAULT NULL; but I end up with the following in the create-table-statement: "device_id"…
Thor A. Pedersen
  • 1,122
  • 4
  • 18
  • 32
2
votes
1 answer

HeidiSQL Before Update trigger error when manually modifying updated column value

BEGIN SET NEW.value_result = NEW.value_a + NEW.value_b; END I'm trying to understand why if I manually modify the value_result column is showing the following error: MariaDB: Error 0 rows updated when that should have been 1. If I modify…
LUE PLAYER
  • 23
  • 4
2
votes
0 answers

Disable autocommit and rollback statments in Heidisql

How to disable autocommit in Heidisql? Also how to rollback update query? I am using version 9.3.0. Using set autocommit = 0; does not work.
Saurabh Jaiswal
  • 21
  • 4
2
votes
1 answer

How to export a small subset of data (full structure) with HeidiSQL

We are managing our web app data with HeidiSQL and MySQL. It is a full database structure with users, listings, transactions, etc. We would like to keep the same full structure, however just export out a small sample of the available data so that…
Freelensia
  • 402
  • 6
  • 18
2
votes
1 answer

Cannot get classic ASP parameterized queries working when using Symmetric key encryption

I have the key and certificate setup ok on the database and I can encrypt ok when entering queries directly using HeidiSQL. But the problem I am having is getting this to work using classic asp. I have setup a simple table for testing which…
jzxz234
  • 35
  • 4
2
votes
1 answer

How to disable automatic update/insert in HeidiSQL when row loses focus

I am using HeidiSQL 9.3.0.5104. If I insert a new row or change a value when using the table GUI (by clicking in a field and typing in it) and then I click outside of that row, HeidiSQl automatically runs an INSERT or UPDATE for that row without any…
Andy Noelker
  • 10,949
  • 6
  • 35
  • 47
2
votes
0 answers

SQL Error (137): Must declare the scalar variable from HeidiSQL

I don't really see where I'm going wrong with this fairly simple query: DECLARE @id int; SET @id = 84; INSERT INTO Activity_Ax_Account_Numbers VALUES(@id,'N/A'); INSERT INTO…
OmniOwl
  • 5,477
  • 17
  • 67
  • 116
2
votes
0 answers

query return data on clinet (ex: HeidiSQL) but return empty from mysql in php

I have a query like that SELECT GROUP_CONCAT(DISTINCT CONCAT('MAX(IF(`TraineeID` = ', `TraineeID`, ',"P","A"))AS ID', `TraineeID`) ) INTO @sql FROM tbl_attn_temp; SET @sql = CONCAT('SELECT DATE_FORMAT(Date,"%d-%m-%Y")AS Date, ', @sql, ' FROM…
Nur Uddin
  • 2,778
  • 6
  • 16
  • 22
2
votes
1 answer

Importing SQL file to HeidiSQL

When I try to import the table and datas to HeidiSQL, I am getting two kind of errors. When Load SQL file and select "Run files(s) directly", the following popup displays and could not be closed When Load SQL file and select "Load file(s) into…
Dhanasekaran
  • 107
  • 1
  • 2
  • 13
1 2
3
…
27 28