Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [heidisql]

Used for the SQL client HeidiSQL.

HeidiSQL is a free, open source SQL client that can connect to many DBMS's, including MySQL, MariaDB, Postgres, and SQL Server. It was created by Ansgar Becker in 2002, and was designed to be easy to learn and use. It has many features including the ability to easily transfer data between tables, databases, and even servers. https://www.heidisql.com/

12 questions
1
vote
1 answer

MySQL Tennis Ladder View Creation Question

I am creating a Tennis Ladder VIEW using MySQL and wish to do the following: Properly create a view that includes: All player's names These player names will come from the table: User - using the field: name Here is a very simple structure of the…
Reno Kendo
  • 21
  • 3
1
vote
2 answers

Connection rejected on MySQL server (error 10060)

I have a small database on a server in my LAN that I try to access remotely via ODBC. Currently, I am making a program in Visual Basic to access, retrieve and display data from the server to an Excel file. Sometimes, the program will stop working…
SuperRamen
  • 13
  • 1
  • 5
1
vote
2 answers

trying to connect to MSSQL server using named pipe in HeidiSQL

I'm trying to connect to a MSSQL server in our office from my local desktop using HeidiSQL. I am able to connect to this server with both SQL Server Management Studio and ODBC with no problems. The connection uses integrated Windows authentication.…
raphael75
  • 244
  • 4
  • 18
0
votes
1 answer

Faster query time but slower response time in 11.4 vs 10.3

I am trying to do a migration for a sever upgrade. The current live system is a Win 2016 server with MariaDB 10.3 on it. The new system is Win 2022 with MariaDB 11.4. Everything is virtual running on VMWare. I have set up the new system, restored a…
rb305798
  • 1
  • 1
0
votes
0 answers

Mariadb can't enforce charset and collation to clients

I'm trying to force clients to use utf8mb4_unicode_520_ci and uft8mb4. I tried to add this to all my galera cluster nodes [mysqld] ... collation-server = utf8mb4_unicode_520_ci init-connect='SET NAMES utf8mb4' character-set-server =…
Freedo
  • 206
  • 2
  • 10
0
votes
1 answer

Join two tables with similar columns

I hva two tables as is: Table univers: client commercial Axel Tony Mike Jhon Chris Jhon Table transactions frclient toclient commission Axel NA 10 Mike NA 8 NA Mike 15 Axel NA 4 NA Chris 5 Chris NA 5 Now, I…
COPEGUEST
  • 33
  • 4
0
votes
0 answers

Error with CREATE DEFINER = root @ PROCEDURE

im getting an error in this script for my project. Im using MariaDB with HeidiSQL v12.2. I dont know what its happen with this script but the error occur at line 85. Sorry for my English. CREATE DEFINER=`root`@`%` PROCEDURE…
Eduardo Estay Atenas
  • 33
  • 5
0
votes
1 answer

Using the correct JOIN

I am trying to create an app for the salespeople who work for my company to keep track of their sales/commission When a salesperson brings on an account, their name is noted on the account and the table might look like Table…
PaulMcF87
  • 177
  • 6
0
votes
0 answers

HeidiSQL, how to export user definition

I am using MariaDB version 10.5.9.0 on Windows version 10.0.19041.928 with HeidiSQL version 11.0.0.5919 I have exported the database structure which includes the tables, stored procedures and data. I also want to export the user I created to access…
SPlatten
  • 149
  • 8
0
votes
1 answer

How to insert '1001-01-01 00:00:00' into MariaDB when altering a table?

I created a table in HeidiSQL: CREATE TABLE `publish_dt` ( `ID` BIGINT(20) NOT NULL AUTO_INCREMENT, `TS` DATETIME NULL DEFAULT NULL, `Text` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_unicode_ci', PRIMARY KEY (`ID`) USING…
Serge Rogatch
  • 115
  • 6
0
votes
1 answer

SQL: How to ask for multiple counts from the same table within a join

Trying to find 3 separate counts within one column of a table, each with separate WHERE clauses. I've got 2 tables in the query, so one join. Thought this looked correct but it will not run: SELECT stores.caption, COUNT ( WHEN…
mtug94
  • 1
  • 1
  • 1
0
votes
0 answers

How can I import table records in HeidiSql?

Im using HeidiSQL and I have imported database from another one. All table structures are imported but not records. I want to import all records for all tables. I have tried to import records for one table using import csv option but its inserting…
user177578
  • 1
  • 1