Questions tagged [heidisql]
Used for the SQL client HeidiSQL.
9
questions
0
votes
1
answer
36
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
631
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
57
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 ...
- 167
0
votes
0
answers
766
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
150
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
3k
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
4k
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 ...
