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
votes
1 answer

SQL Entry's Duped

I messed up when trying to create a test Database and accidently duplicated everything inside of a certain table. Basically there is now 2 of every entry there was once before. Is there a simple way to fix this? (Using InnoDB tables)
user3759691
  • 1
-1
votes
2 answers

SQL syntax error near '' at line 14

I have created this trigger in HeidiSQL IDE for mysql trough IDE´s helper and it worked pretty good. If I copy the create code generated by the IDE and try to run it on phpmyadmin I get a SQL syntax error that I just can´t figure how to fix it. Can…
Daniel
  • 273
  • 4
  • 18
-1
votes
2 answers

SQL/PHP syntax not working

I want to use a SELECT LIKE for a string , to get some data from a table.But for some reason the following code does not work.Any clues as to why ? I use HeidiSQl and PHP 5.3. if(isset($_GET["name"])){ …
Johny
  • 163
  • 1
  • 11
-2
votes
1 answer

I'm confused with var vs varchar

https://i.stack.imgur.com/TrOtF.png Please see picture above and explain me why it says in CHAR that trailing spaces are removed and why VARCHAR says that does not remove trailing spaces. I thought VARCHAR was the one that removed the whitespaces in…
eberteo
  • 23
  • 5
-2
votes
2 answers

How to update stored procedures in multiple databases in mysql

I am very new to mysql and I have I a situation where I need to update all my stored procedure in all my database. for example I have 10 database just say: client_1,client_2,client_3,.....client_10. Every database have same stored procedure just…
Akash Verma
  • 67
  • 2
  • 6
-2
votes
1 answer

Select table from column value MySQL

we have a SQL table "ContactLot" in this table we have a column "contactTableName" and "creationDate", i'm tring to get all ContactLot after 2020-02-01 (here i can use creationDate column" and then i want to get some values from every table in…
Brahim Djarallah
  • 93
  • 1
  • 9
-2
votes
1 answer

error sql (1064): you have an error in your SQL syntax''

I want run this query but get an error: error sql (1064): you have an error in your SQL syntax; check the manual that corresponds to your MariaDB server Version for the right syntax to use near '' at line 97 My Query is: CREATE PROCEDURE…
AdriAnna CQ
  • 1
-2
votes
1 answer

Understanding this SQL Syntax

load data infile 'D:\\diiet\\subir\\a.txt' Into table reporte_dts_empresa_2015_sut CHARACTER SET latin1 fields terminated by '\t' Why do I have to do this step? LINES TERMINATED BY '\r\n' IGNORE 1 LINES; I am new on sql, I'm trying to create a…
Andrés Silva
  • 11
  • 1
-2
votes
2 answers

PHP query returning only one row out of four

This query was supposed to return me four rows: which are four people with status 50 (which, in the application means "maternity leave"). But it returns only one. On HeidiSQL the query doesn't even run because it displays a syntax error on line…
user10847903
  • 1
-2
votes
1 answer

add variable with Update Set

i want to add new variable without deleting old variable with using Update Set. i added example of my table and i wrote below the query. How can i do? update ActionsProperties set PropertyValue = PropertyValue + ',x@x' where PropertyValue = 'y@y'…
Mnks
  • 9
  • 3
-2
votes
1 answer

MySQL Error Unknown column in 'on clause'

I've tried to join 3 tables: a, b and c. my current code: SELECT a.a_id, a.variable1, a.variable2 FROM b LEFT JOIN a ON a.a_id = b.a_id LEFT JOIN c ON c.c_id = b.c_id WHERE a.variable1 IN ('1', '4'); now I get "Unknown column 'a.id' in 'on…
pfandflaschen
  • 45
  • 6
-2
votes
1 answer

Attribute consists of other attributes, MySQL

I want to implement the attribute "name". this attribute consists of the 2 other attributes "firstname" and "lastname". my code: firstname VARCHAR (30), lastname VARCHAR (30), name VARCHAR (firstname, lastname) but i get the error that the syntax…
pfandflaschen
  • 45
  • 6
-2
votes
2 answers

SQL Error(1166) : Incorrect column name 'id'

I am new to yii and heidiSQL while am creating new table i get this error,so help me to solve this error CREATE TABLE `users` ( `id ` INT(45) NULL, `username ` VARCHAR(50) NULL, `pwd_hash` VARCHAR(50) NULL, `fname` VARCHAR(50) NULL, …
Sandhiya C
  • 49
  • 2
  • 10
-3
votes
1 answer

MySQL IFNULL syntax on outer query to return a record when query does not return any records

I'm looking for guidance on how to apply IFNULL to an outer query in my mySQL Query. The query checks for new timecards submitted the previous day and kicks off a procedure that writes the results to a file server. Frequently there are no records…
Scanpennett
  • 1
  • 1
-3
votes
2 answers

Count Nested Case in SQL

I want to display a rows train with id_user and id_train Can I nested a case statement in count function sql? My SQL is here but it errors SELECT ticket.* , COUNT( CASE trans.id_user WHEN 1 THEN 1 CASE trans.id_train WHEN 1 THEN 1 ELSE…
M Muqiit Faturrahman
  • 79
  • 12
1 2 3
…
27
28