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
0
votes
0 answers

HeidiSQL is not showing any data even when table size is more than 0B

I have Postgresql Database in production and i'm trying to insert data from my localhost using psycopg2 library. i'm seeing my database through HeidiSQL. But after i finished inserting the data, my HeidiSQL shows that table size increased but when i…
Michael Halim
  • 262
  • 2
  • 20
0
votes
1 answer

update cell data with results from procedure

i would like to run a procedure on a schedule, take the results from that procedure and input that data into a cell. BEGIN select location from StartPositions where id = (FLOOR(1 + RAND() * (5 - 0 +1))); UPDATE wanderingtrader.npcs SET…
Budd ItzBuddTTV
  • 1
0
votes
2 answers

combine the results of two queries with different group by clause

I have a use case where I want to calculate the number of dates which had stocks in and out. My tbl schema has just 4 cols : stock_type, in_date, out_date,…
John
  • 3
  • 2
0
votes
1 answer

Why my database only updates when I create another table?

I am using Jupyter notebook to run some SQL queries. The queries are working because I can print them on my screen using pd.read_sql Here is the code to insert the data in the SQL table: cur.execute("CREATE TABLE table_1 (col_1 INT, col_2 INT, col_3…
Maite Martinez
  • 1
  • 1
0
votes
0 answers

How to set limit for accessing data in heidisql?

By default, limit of accessing data in Heidi SQL is upto 100000. SELECT * FROM tablename WHERE columnname='value' and 'column_name'='value';
Akhilesh Dhiman
  • 15
  • 7
0
votes
1 answer

Automatic MariaDB table replication between 2 databases on the same server

So a friend of mine asked me to help him configure an automatic replication of a table on his MariaDB database to another table that's supposed to be an exact copy of the source/primary table. The databases are on the same server. MariaDB version…
AuRuM
  • 27
  • 1
  • 4
0
votes
0 answers

How to save the octothorpe(#) into the JSONB field of the postgresql database?

I tired to update the value for the languages EN and DE into the field introduction of table landingpage. UPDATE landingpage SET introduction = introduction::jsonb || '{"EN":"#1","DE":"#2"}' WHERE id = 5; But I got alway the error: Your query…
WaYi1688
  • 1
  • 1
0
votes
1 answer

ayuda , how to use concat on heidi sql?

in version 12 of hedisql there is still concat or how to do it ?? CREATE VIEW imagen as SELECT asset_tag.asset_id FROM asset_tag GROUP BY asset_tag.asset_id ; SELECT concat_ws(',',asset_tag.tag_id) FROM ( SELECT imagen.asset_id FROM imagen WHERE…
A izag alba
  • 23
  • 6
0
votes
1 answer

SQL Loops to insert dummy data?

Part of my job requires that I insert hundreds of fields into a table each week, and I'm getting honestly tired of doing it by hand. SQL is not my forte, so I was wondering if there could be a way to do it semi-automatically? The query I need to…
Fernando LimnCaducado Snchez M
  • 1
0
votes
1 answer

MySQL, query for finding patient readmissions, 30 days after discharge date

I have a table that has columns visit_no, mr_no, admit_date, admit_time, dischg_date, dischg_time, and other columns that aren't necessary for the query. mr_no is the main identifier of the patient, a patient can have multiple visit_no with their…
oscarmnz8
  • 5
  • 1
  • 3
0
votes
1 answer

How to convert this stored procedure to retain or delete data from past 7 days

Where IFNULL(d.updated,d.inserted) < (CONCAT(YEAR(NOW()), "",MONTH(NOW)), "", "01") -INTERVAL ',date_logs,' DAY):"): Question : I need to create a stored procedure that cab delete data from past 7 days the above codes is for 30 days only .please…
Stella
  • 19
  • 6
0
votes
1 answer

Export MySQL Database from HeidiSQL to SQL Server. Problem with simple quotes

I have a remote MySQL DB in a hosting that I need to export to my local SQL Server. I use Heidi SQL to connect the DB and I use the Export to single .sql file The problem is that the DB is 5GB and the .sql file is 2.3GB. So I can't open the .sql…
Keras-JOB
  • 109
  • 10
0
votes
1 answer

How can I ignore errors when importing SQL in HeidiSQL?

I'm using HeidiSQL to add some new data to a database. My file contains ~200 queries, but one throws an "value already exists" exception and then the remaining queries after the offending one don't run. How can I just ignore any exception-causing…
Salvatore
  • 10,815
  • 4
  • 31
  • 69
0
votes
0 answers

Request sql for computed column (age)

I have trouble with my computed column for calculate automatically age. I use latest version of Laragon, with HeidiSQL (11.2.06213). See the request : CREATE TABLE client( id_client Int Auto_increment NOT NULL , …
jeremy
  • 23
  • 6
0
votes
1 answer

How to transfer favorites tree items from one db to another in HeidiSQL?

I'm trying to transfer favorites tree items from one database to a new one. Sometimes I have to import a database from my production environment into my local environment, and I have to name it differently (e.g. DB-0028) to keep my local database…
Frantic09
  • 1
  • 1
1 2 3
…
27 28