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

In needing of a MYSQL Timer

HeidiSQL Hello Guys im an newbie on the MYSQL side, all my aknloedge on it being pretty basic functions, i wanted to ask if anyone here has links to good tutorials such as web/videos, to learn how to set up an mysql timer on my database, to delet an…
Hélio Sanches
  • 1
-1
votes
1 answer

Cannot get data from database

not sure why this code isn't working for my library management system. seems like everything should work but every single time I run it I get the error messagebox. Anybody have any ideas? It's for a library management system coded in pycharm, I've…
Jun Seo Lee
  • 1
-1
votes
1 answer

Can not create foreign keys and check constraints using HeidSql

I am trying to create some tables in HeidiSql, but got stuck at the point I noticed that I can not create foreign keys. At first I tried it with SQL statements and later on with the key generation menu of HeidiSql. Both ended in giving me an index…
Juventino1897
  • 29
  • 6
-1
votes
1 answer

SUM() with a COUNT() statement

I'm wondering if it is possible to sum specific values after a count statement. At the moment I have: SELECT roles.Name AS Role_Name , COUNT(DISTINCT ur.UserId ) AS RoleCount FROM dbo.AbpUsers as users LEFT JOIN…
Samuel Van Bladel
  • 37
  • 3
  • 10
-1
votes
1 answer

Calculating daily volumes from total volume

I have the following data: ID Date Total A 2021-09-03 0 A 2021-09-04 12 A 2021-09-05 37 A 2021-09-06 40 B 2021-08-03 20 B 2021-08-04 43 B 2021-08-05 75 And from this data, I would like to get the following…
mas123
  • 31
  • 5
-1
votes
1 answer

MySQL: Updating multiple columns using if else

I need help to set a mySQL update query for my little project like below: UPDATE TABLE IF SUBSTRING_INDEX(REFERENCE, '_', -1)= 'A' THEN { TYPE = 1 COLOR = 'BLUE' } ELSEIF SUBSTRING_INDEX(REFERENCE, '_', -1)= 'B' THEN { TYPE = 2 COLOR =…
Relinwar
  • 93
  • 5
-1
votes
3 answers

MySQL updating a column's values with multiple conditions

I'm new to MySQL and I'm currently trying to learn to become more efficient in it. In this case, I have a database that has people's incomes and I want to create a new column income_level that says low, middle or high income based on the income. I…
coderfrombiz
  • 115
  • 8
-1
votes
1 answer

SQL: How to Order By the attributes in Descending but second character of it need to be Ascending Order

How to produce this output in MySQL? Sort the albums first based on the album format in descending order followed by the tracks in ascending order. I can come out the output with this command: SELECT album_singer, album_name, album_format_name,…
Kingsley Yong
  • 83
  • 8
-1
votes
2 answers

How to select the latest salary under some other conditions? MySQL

I want to select just the latest salary of senior, female employees. I have the following query by now: SELECT e.emp_no, e.gender, tit.title, s.* FROM employees e INNER JOIN titles tit ON tit.emp_no = e.emp_no INNER JOIN salaries…
big_OS
  • 381
  • 7
  • 20
-1
votes
1 answer

MySql cannot update a DATETIME field - no record found

I have a table in MySql 5.6.10 defined as this: When I do a select query (from HeidiSQL client) for a particular record filtering on the id_failed_delivery_log column, the record is found successfully, but when I use the same filter for the UPDATE…
Vortanz
  • 47
  • 1
  • 5
-1
votes
1 answer

PHP mail error domain missing or malformed

I'm trying to send a mail to a customers email thats set in my database. $subject = 'Testing PHP Mail'; $txt = 'This mail is sent using the PHP mail function'; $headers = "FROM: test@gmail.com"; $query = ("SELECT email FROM ps_customer where…
user10384599
-1
votes
1 answer

SELECT IF EXISTS ELSE INSER, Mysql

i have problems with my sql-statement and coulnd't find a solution to this in the already asked questions here. my statement is: IF EXISTS (SELECT LastLogin FROM user WHERE Email = @mail) SELECT LastLogin FROM user WHERE Email = @mail ELSE INSERT…
catcat
  • 21
  • 6
-1
votes
1 answer

how to get my data shown in my dynamic URL with PHP

How should my test.php get data from a database? My database name is "example" and the things i want to get are test1, test2, test3.
notsoeasy
  • 41
  • 1
  • 9
-1
votes
1 answer

Displaying one column from inner query

Please help me solve this: SELECT a.prs_code, a.cc, b.description FROM idp_inpadoc_prs_cc a, idp_inpadoc_cat_desc b WHERE a.ID = b.ID AND a.prs_code IN (SELECT prs_code FROM …
user6662778
-1
votes
2 answers

heidisql - create database with uppercase Camel Case Format

i create table with Tbl-ProductModifierGroup but on HeidiSQL it will display tbl-productmodifiergroup, how to slove this problem? Can i create table with CamelCase Format? which is Tbl-ProductModifierGroup
Mike
  • 177
  • 1
  • 2
  • 13
1 2 3
…
27 28