Skip to main content

Questions tagged [heidisql]

Used for the SQL client HeidiSQL.

Filter by
Sorted by
Tagged with
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 ...
Freedo's user avatar
  • 196
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 ...
Reno Kendo's user avatar
0 votes
0 answers

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 ...
Mike's user avatar
  • 13
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 ...
COPEGUEST's user avatar
1 vote
1 answer

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 ...
SuperRamen's user avatar
0 votes
0 answers


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 ...
Eduardo Estay Atenas's user avatar
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 ...
PaulMcF87's user avatar
  • 167
0 votes
0 answers

HeidiSQL, how to export user definition

I am using MariaDB version on Windows version 10.0.19041.928 with HeidiSQL version I have exported the database structure which includes the tables, stored procedures and data. I ...
SPlatten's user avatar
  • 149
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'...
Serge Rogatch's user avatar
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 ...
raphael75's user avatar
  • 244
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 ...
mtug94's user avatar
  • 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 ...
user177578's user avatar