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
2
votes
1 answer

Viewing MariaDB column_list result via DBForge

Using the example in provided by DBForge for COLUMN_LIST against the table assets, when I run the following: SELECT item_name, column_list(dynamic_cols) FROM assets; Through DBForge Studio, the resultset for column_list(dynamic_cols) is shown as an…
YCY
  • 21
  • 1
2
votes
4 answers

SQL Server AUTO_INCREMENT error

Interface: HeidiSQL Database: SQL Server I'm trying to create table keeping ID (int) column as primary key as well as Auto_Increment. But SQL Server is throwing Error 102: Incorrect Syntax near 'Auto_increment'. Please Help. Thanks.
Anubhav Chatterjee
  • 21
  • 1
  • 1
  • 2
2
votes
1 answer

Left join appears to be hindering SQL query performance tremendously

I have two tables: Table A: Name, isPair Table B: Name1, Name2, Status This is my query: SELECT Name FROM A LEFT JOIN B ON (A.Name = B.Name2) WHERE A.isPair = 'T' AND (B.status <> 'valid' OR B.status IS NULL) I have millions of rows in both…
Mitchell
  • 169
  • 1
  • 14
2
votes
1 answer

Update Query issue . 0 rows updated when there should have been 1. HeidiSQL

I have a table like this: ALTER TABLE `MW_Locations` CHANGE COLUMN `ID` `ID` INT(20) NULL DEFAULT NULL FIRST, CHANGE COLUMN `UDID` `UDID` INT(20) NULL DEFAULT NULL AFTER `ID`, CHANGE COLUMN `IDACCOUNT` `IDACCOUNT` INT(20) NULL DEFAULT NULL…
Arnoldo Bazaldua
  • 187
  • 1
  • 2
  • 9
2
votes
3 answers

Create SQL column relative to another

I have a column with different values : 1 2 4 8 I want to create a new column in the same table based on these values. For example, if the value is 1 or 4, I want to display the corresponding line in OK and NOT OK for the rest. Like: 1 OK 2…
user2207976
  • 39
  • 3
2
votes
2 answers

SQL substring replacing

I am using HeidiSql and I have a database with ~1000 URL's.…
Marbury
  • 21
  • 4
2
votes
2 answers

access Database with HeidiSql like PHPMyAdmin (localhost)

is it possible to access a Database with HeidiSql like PHPMyAdmin, if the DB is only reachable over the web (localhost-Settings).
user1283178
  • 21
  • 1
  • 3
2
votes
1 answer

What's wrong with this trigger?

I'm using MySql with HeidiSql as an IDE. I have the following trigger: BEGIN declare blobpassed blob(50); declare gid integer(10); select lt.groupid into gid, GROUP_CONCAT(passed) into blobpassed from latest_tests lt left join testcaseresults…
Nacht
  • 10,488
  • 8
  • 31
  • 39
1
vote
1 answer

What is the difference running a SQL statement on psql and administration tools?

There is a discrepancy when I run the following SQL statement on different clients: SELECT 13323::REGCLASS; OID 13323 in my database belongs to sql_sizing. When I run the query in psql the output is: …
Umut TEKİN
  • 856
  • 1
  • 9
  • 19
1
vote
0 answers

Run PostgreSQL built-in functions in HeidiSQL

I'm trying to run the sha256 function in HeidiSQL, but I'm getting that function doesn't exist. The query is the following: UPDATE db_name.users SET db_name.users.password = sha256(db_name.users.password) WHERE user_id = (secret_numeric_id); Is…
Álvaro
  • 385
  • 5
  • 15
1
vote
1 answer

can I add values into a column conditionally in mysql via a query (heidisql)?

I'm having trouble inserting values conditionally into a column via a query. I am trying to add the following: low, med, high into a new column called income_level which is based on the value in column income. What i wish to query: INSERT INTO…
cba
  • 13
  • 2
1
vote
2 answers

how to use concat, like and subconsultas with where?

SELECT asset_tag.asset_id, LEFT(asset_tag,SUBSTRING(asset_tag)-1 AS 'ETIQ' from (SELECT DISTINCT S2.asset_id + ',' AS etiquetas (SELECT S1.tag_id FROM asset_tag AS S1 WHERE S1.tag_id ORDER BY…
A izag alba
  • 23
  • 6
1
vote
1 answer

Im encountering syntax error 1064 on my MySql stored procedure

Hi rephrasing my question earlier I added the full statement below.codes should retain data from past 7 days.Thank you. CREATE PROCEDURE logs_user_aht_delete( IN logs_database VARCHAR(25) CHARACTER SET utf, IN logs_data_retention_db INT(10)…
Stella
  • 19
  • 6
1
vote
2 answers

Trying to create query to export data as csv

I have a Postgresql table I wish to export as CSV on demand using a query, without superuser. I tried: COPY myapp_currencyprice to STDOUT WITH (DELIMITER ',', FORMAT CSV, HEADER) \g /tmp/prices.csv But I get a syntax error at "\g" So I tried: \copy…
Rick Loterio
  • 11
  • 2
1
vote
2 answers

Setting up Azerothcore. Where do I find and how do I edit the realmlist table in Heidi to allow computers on my LAN to join the server?

Edit: so we never obtained the answer, instead we tried it with the server and client on the same PC. This morning I tried logging into the client and it would hang on "authenticating". So I shut everything down and went back to my life for a bit.…
Jennifer DeCuir
  • 21
  • 2
1 2 3
…
27 28