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
vote
0 answers

PostgreSQL displaying integer inserted without commas, with commas (formatted like currency or similar)

SQL Server guy, new to PostgreSQL. Created the below table, performed the below insert, then ran a SELECT to see the data, yet the row shows the integer formatted with columns to break up the integer. Is this just a formatting style in the HeidiSQL…
JamesMatson
  • 2,522
  • 2
  • 37
  • 86
1
vote
3 answers

SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use

I have an issue while executing UPDATE statement. UPDATE vehicles2 SET limit = @newlimit WHERE model = @vehiclenew Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for…
S.Malka
  • 11
  • 2
1
vote
2 answers

Importing CSV file to HeidiSQL, error 1148

I'm completely novice to MySQL, and I'm trying to load some CSV sheets to the server using HeidiSQL -> tools -> Import CSV. But it keeps giving me this error: Error 1148: The used command is not allowed with this MySQL version". Is there a way to…
EwokJedi
  • 25
  • 2
1
vote
1 answer

Stored Procedure in Java Spring Boot Project returns null as Output

I'm using a stored procedure in a Spring Boot project and trying to get an output value, but in my project it always returns null. But if I'm calling the procedure through HeidiSQL it works and gives me the right value. So it has to do something…
Constantin Beer
  • 5,447
  • 6
  • 25
  • 43
1
vote
1 answer

Trying to restore a backup with a generated SQL query results in syntax error

I have made a database backup with heidisql. When I try to restore the backup, I get A syntax error. The query that heidiSQL generated for me: CREATE TABLE IF NOT EXISTS "age_categories" ( "id" INTEGER NOT NULL DEFAULT…
user2315111
  • 65
  • 4
1
vote
1 answer

Counting data falling within certain month in mySQL

Hi I'm having trouble sorting image data by month, I'd like to be able to tell how many images were created, updated and deleted within a certain month by getting the count and grouping then by the month. I have two tables with image data in. Both…
Sir Catzilla
  • 321
  • 3
  • 18
1
vote
1 answer

MariaDB default float can't contain decimal places

I am learning about MariaDBs column types and noticed this on my MariaDB db (latest dockerized 10.3.13), connected via HeidiSQL 10. I can't set the default value for my FLOAT column to a value that contains decimal places: After hitting save the…
FabianTe
  • 516
  • 4
  • 22
1
vote
1 answer

composite primary key as foreign key deleting one set delets all

I have two tables one of them has composite primary key and the other has foreign keys to it. They both are set to cascade on delete. The problem is when I delete lets say a composite key set "name: John date: 02.02.2018" from the main table all the…
ivaylo
  • 811
  • 2
  • 9
  • 25
1
vote
4 answers

Is it possible to use two COUNT and two JOIN in a SQL query from 3 tables?

So what I'm trying to do here is get a report on how many emails (with a MailChimp like app) were sent by different users, but I want two different metrics in one query. I want to know how many individual emails were sent by each user. Meaning if…
G. Langlois
  • 75
  • 1
  • 8
1
vote
0 answers

How to export javascript array to MySQL database

I'm having an array in JavaScript to show as a selector in my web page. Now I want to export this array to MySQL database and make the selector in my web page editable from user interface. I'm having trouble in saving the array in the…
T.K. Tamil Arasi
  • 11
  • 5
1
vote
0 answers

making sending email automatically (cron job)

I'm sending a email using php: use PHPMailer\PHPMailer\PHPMailer; require 'Exception.php'; require 'PHPMailer.php'; require 'SMTP.php'; require 'PHPMailerAutoload.php'; $mail = new PHPMailer(); $mail->IsSMTP(); // telling the class to use…
user10384599
1
vote
3 answers

sql query doesn't select the right value's I need

I'm trying to only select the data with numbers in them (the table looks like this): eteee 231 wrgrr test 1 bioo 21 wee with the query: SELECT address1 FROM ps_address WHERE address1 not like '%[^0-9]%'; but i get all the values right back.
user10384599
1
vote
1 answer

I get the following error when import CSV to a table in Heidi SQL "SQL Error: Data truncated for column 'SlNo' at row 1"

I have saved a dataframe (pandas) in python as a CSV file and am trying to import it into a table using Heidi SQL and I get the error "SQL Error: Data truncated for column 'SlNo' at row 1". Here is the error: Here is my table: And this is the CSV…
Shobhit Kumar
  • 626
  • 1
  • 5
  • 21
1
vote
1 answer

Split date into multiple columns

I've been searching for hours but haven't been able to find an answer. I'm hoping somebody might know how to split a date into 3 columns. I have a mysql table that looks like the following Id Email First_Name Last_Name DOB Gender 1…
J.R.
  • 59
  • 1
  • 9
1
vote
1 answer

Access denied message when starting HeidiSQL

I installed HeidiSQL to use MariaDB. When HeidiSQL created and opened a session, the following message appeared. / * Start "MyDB" session * / / * Access denied * / Access was denied, but basic SQL was available. Environment: Win10 x64, MariaDB…
Day Break
  • 88
  • 10
1 2 3
…
27 28