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

Why my stored procedures in MariaDB do not appear when connect to Tableau?

I don't know why but I can not see the stored procedures appear when I connect the database to Tableau (I use MariaDB). I can only see the data tables. Anyone has the same problems with me? I am a newbie so I am not sure if my description is clear…
Dzung Hoang
  • 11
  • 1
1
vote
1 answer

sqlQuery where timestamp is a specific date

Hy guys I have this table: VisitedCity id timestamp name city 1 2022-02-02 10:02:23 Mark LA 2 2022-01-15 08:45:01 Phil NY 3 2022-02-05 11:09:45 John MI My query : SELECT * FROM VisitedCity WHERE timestamp = '2022-02-02' But it…
gianluca23
  • 23
  • 5
1
vote
1 answer

Alter/change default value for sequence on postgreSQL

I would like to alter my sequence value in database. On top of that, I tried to get the sequence info by below query SELECT PG_GET_SERIAL_SEQUENCE('test_thing', 'id'); which is it return to NULL. Further check in Postgres (using HeidiSQL) db for…
Azlina T
  • 176
  • 2
  • 17
1
vote
2 answers

Query with email headers from special Latin characters rejected by PHP mysqli_query and MariaDB command line, works in HeidiSQL

I have encountered a scenario where an email from someone in Europe keeps failing to execute. After minimizing the query I've determined that after all special characters like å and é are removed the query works fine in PHP / mysqli_query. The…
John
  • 1
  • 13
  • 98
  • 177
1
vote
0 answers

Query is showing result of utility bills while converting bills table rows into column, in where clause, between operator" is not giving any result

The query is showing the result of utility bills while converting bills table rows into column, in where clause, the second condition is month, but "between operator" is not giving any result, the datatype of ub.c_month is varchar SELECT…
Ahmed Akram
  • 11
  • 2
1
vote
2 answers

SQL: Looping over query result

Regarding company tree in PostgreSQL I am using the following to get the subsidiaries of the company with id = 11. SELECT * FROM "OwnershipTable" WHERE "Parent_ID" = 11; giving me the following…
Frederik Grut
  • 11
  • 1
1
vote
2 answers

SQLSTATE[HY000]: General error: 1364 Field 'name' doesn't have a default value (SQL: insert into `products` (`featured_image`

SQLSTATE[HY000]: General error: 1364 Field 'name' doesn't have a default value (SQL: insert into products (featured_image, product_attributes, updated_at, created_at) values (7wtDzLjyBAIIGzQBSXVBwKqnuUPmh1OGLVpxLd2H.png, null, 2021-03-09 02:11:00,…
yan2412
  • 11
  • 1
  • 4
1
vote
2 answers

HeidiSQl error for MariaDB for wrong syntax

I am getting this error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near Here is my SQL: UPDATE product SET cost_price = db2.supplier.Cost_price FROM product,…
Mustafa Patharia
  • 13
  • 4
1
vote
2 answers

MySQL Where-clause with select

I have a table that has three columns: visitations, country and user_id. I have a query to retrieve amount of all visitors per country and re-visitors per country. Now, I would like to alter my query so, that I get both amounts and a ratio of…
coderfrombiz
  • 115
  • 8
1
vote
2 answers

MySQL: Is there a way to select a column and use it in "multiple ways"?

I'm learning MySQL and I'm facing a problem that I cannot find an answer to. I have a database that includes columns: company and company_response. I have now queried the companies in a descending order so that the company that has closed most…
coderfrombiz
  • 115
  • 8
1
vote
1 answer

How do I connect to MySQL unix socket via SSH tunnel using HeidiSQL?

I'm properly establishing SSH tunnel and I can connect to MySQL users accesible via tcp connection but I don't know how to connect to users accesible only by unix socket. I know the correct socket location: /var/lib/mysql/mysql.sock and I can…
Grzegorz Adam Kowalski
  • 5,243
  • 3
  • 29
  • 40
1
vote
1 answer

My postgresql function created with HeidiSQL is not returning results

v_all_my_tables contains a single column (from charvar) which I'd like to loop through and run a select query on. HeidiSQL creates the function using the code below. However, when I run routine, no results are returned and this error is…
krafty1010
  • 19
  • 3
1
vote
1 answer

SQL Server guy working with PostgreSQL now, failing to create simple stored procedure - error Unterminated dollar quote

I am starting out with PostgreSQL and have realised that while working with C# and EF Core I have a set of logic that would work better in a stored procedure in the database. However I've come from a SQL Server background, so writing PL/pgSQL is a…
JamesMatson
  • 2,522
  • 2
  • 37
  • 86
1
vote
0 answers

Inserting doubles into my database seems to be ignoring the (M,D) floating point syntax

I have a mysql 5.7.25 database hosted on Amazon RDS I'm trying to insert doubles to. I inherited roughly 40 columns all Datatype DOUBLE with the Length/Set as reported by heidisql as (22,0). For months now I've been inserting data to this table and…
jawknee530
  • 319
  • 4
  • 12
1
vote
1 answer

error in creating stored procedure using heidiSQL

I am trying to write a stored procedure using Heidi sql. I am getting below error. I tested the query and it returns right result, but in Heidi sql, I keep getting below error: Below is my query and the screen shot from heidiSQL: DELIMITER…
Anjali
  • 2,540
  • 7
  • 37
  • 77
1 2 3
…
27 28