distal-attribute
distal-attribute
distal-attribute
distal-attribute

HeidiSQL 6.0 released

User, date Message
Written by ansgar
4 years ago
Category: Anouncements
4940 posts since Fri, 07 Apr 06
This is a new release of HeidiSQL, the result of 331 changes done after the previous 5.1 release. HeidiSQL 6.0 introduces many new features of which I'll list the most important ones here:
- Tabs for multiple batch results or multiple procedure results in a query tab.
- Multiple connections in one application instance
- Editable query results
- Rewritten user manager, using GRANT and REVOKE syntax now
- Rewritten "Copy table" dialog and logic, supporting WHERE filters now
- Rewritten "Load text file" dialog and logic, supports client side parsing for situations where LOAD DATA is not allowed
- Rewritten SQL help dialog
- Query profiling in query tabs
- Introduce "Run current query" action (Shift+Ctrl+F9)
- Enhance detection of Unicode text files
- Server details hint when mouse over version status panel
- Internal image previewer for BLOBs
- LaTeX and Wiki markup output for grids
- ZEROFILL support in table editor
- Session manager: Prompt for username and password on demand
- Add support for TIME values above 24 hours
- Tons of bugfixes

Grab it
Written by Dr. DaveMoney, Euro
4 years ago
105 posts since Sun, 27 Jan 08
Well... seems though you can't create any users.

Keep getting: SQL Error (1133):Can't find any matching row in the user table
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
Looks like you activated SQL mode NO_AUTO_CREATE_USER, which does avoid to create users when you don't specify a password. Please type a password for new users in that case. The error message is though a bit misleading, but that's up to MySQL itself.

See
http://bugs.mysql.com/bug.php?id=7000
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
Written by giuliano
4 years ago
19 posts since Sat, 19 Dec 09
Hi,
To avoid this problem, Heidi could launch the CREATE USER statement before launching the GRANT statement (when you create a new user).
Or Heidi could use "GRANT .. TO .... IDENTIFIED BY password".

I noticed HEIDI doesn't use the "IDENTIFIED BY" clause, but use two statement (GRANT and SET PASSWORD).

I think that if you'd use "GRANT ... IDENTIFIED BY...", the error wouldn't occur.
Written by JonoB
4 years ago
4 posts since Sun, 21 Nov 10
When executing queries, the query tab used to show the number of records returned, and the execution time. Where do we get that information now?
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
Please look into the lower log panel. This was moved in order to save space for the result grid when sub tabs were introduced.
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
giuliano, you're right - that would at least solve that problem when a password was given. Will check that.
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
CREATE USER implemented for 5.0.2+ servers in r3606. Old servers still use the SET PASSWORD query, which should never fail as NO_AUTO_CREATE_USER mode was added in MySQL 5.0.2, as was CREATE USER.
Written by Dr. DaveMoney, Euro
4 years ago
105 posts since Sun, 27 Jan 08
Thanks, Anse. Creating new users works great now. smile
Written by JonoB
4 years ago
4 posts since Sun, 21 Nov 10
Using -- to comment out lines in the query window causes an error.
Not closing /* with */ causes an error (*/ shouldnt be required if, for example, you are commenting the last line in the query)
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
"-- " syntax works here. Error message?

"/* " is not valid for MySQL. You must indeed include the closing stuff.
Written by JonoB
4 years ago
4 posts since Sun, 21 Nov 10

SELECT a.id, a.name
--, a.code
FROM account a



#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' a.code FROM account a' at line 2
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
"--" comments need a space afterwards. See http://dev.mysql.com/doc/refman/5.1/en/comments.html .

Just the syntax highlighter is perhaps misleading as it displays the two dashes without space as comment, but that should be fixed in SynEdit.
Written by JonoB
4 years ago
4 posts since Sun, 21 Nov 10
Thanks for clearing that up. I thought that the previous version worked without spaces, but no matter.
Written by giuliano
4 years ago
19 posts since Sat, 19 Dec 09
The space after "--" is the "non-ANSI" part of MySQL SQL syntax for comments.
AFAIK, it was always required, and it doesn't depend on HeidiSQL but on MySQL.

Written by mitislumen
4 years ago
1 posts since Tue, 23 Nov 10
I just wanted to say, HeidiSQL is the best MySQL manager I have used. Nice work developers, version 6.0 works really well and is extremely useful and helpful for me, my life would be much much harder without it. Thanks you all for this.
Written by admintiger
4 years ago
3 posts since Tue, 23 Nov 10
I agree. HeidiSQL is also the best MySQL manager I have used. I use it daily on several servers and greatly appreciate the work that is so generously contributed developing and continually improving it.
Written by michaelgangMoney, Euro
4 years ago
45 posts since Wed, 17 Nov 10
great work !!! smile
Written by acio83
4 years ago
1 posts since Thu, 02 Dec 10
Great app! but I'm missing theraded execution of queries. It's not cool to block the UI while executing a query. Also, a button to cancel the query would be nice.

Still I like it a lot and it's the app I use everyday, so thanks a lot!
Written by nthdesignMoney, Euro
4 years ago
2 posts since Fri, 10 Dec 10
It looks like HeidiSQL is injecting a semicolon onto the end of every statement. For instance, consider the following statement:

DELIMITER $$



This statement now fails in HeidiSQL 6, when it worked fine in all previous versions of HeidiSQL. If you look in the statement log, you'll see that HeidiSQL is actually running the following statement:

DELIMITER $$;



Other than that, everything in HeidiSQL 6 has worked fine for me!

Thank you for putting so much effort into HeidiSQL. It is a tool I use every single day.
Written by nthdesignMoney, Euro
4 years ago
2 posts since Fri, 10 Dec 10
I generally use the delimiter statement when creating stored procedures. For instance, I might execute the following SQL code:

DELIMITER $$

DROP PROCEDURE IF EXISTS spHelloWorld $$
CREATE PROCEDURE spHelloWorld()
BEGIN
SELECT 'Hello World!';
END $$

DELIMITER ;


As a follow-up, the workaround to this is to use the delimiter feature built into Heidi. If I click the delimiter button, and specify "$$" as my delimiter, then I can execute just the following:

DROP PROCEDURE IF EXISTS spHelloWorld $$
CREATE PROCEDURE spHelloWorld()
BEGIN
SELECT 'Hello World!';
END $$

 

Please login to leave a reply, or register at first.