Questions tagged [heidisql]
Used for the SQL client HeidiSQL.
13 questions
0
votes
1
answer
127
views
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 ...
- 1
0
votes
0
answers
101
views
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 ...
- 196
1
vote
1
answer
38
views
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 ...
- 21
0
votes
0
answers
43
views
MySQL-Proxy works with HeidiSQL but not with DBeaver nor Workbench
For data analytical applications, our current development environment relies on a MySQL-Proxy (version 0.8) to connect to the MySQL data source. And the MySQL's version is 5.7.43-47-log.
We noticed ...
- 23
0
votes
1
answer
42
views
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
...
- 33
1
vote
1
answer
2k
views
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 ...
- 11
0
votes
0
answers
119
views
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 ...
0
votes
1
answer
42
views
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 ...
- 177
0
votes
0
answers
939
views
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 ...
- 149
0
votes
1
answer
182
views
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'...
- 115
1
vote
2
answers
5k
views
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 ...
- 244
0
votes
1
answer
5k
views
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 ...
- 1
0
votes
0
answers
2k
views
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 ...
