Alternatives to FlySpeed SQL Query for all platforms with any license

Platforms

Show 3 less popular platforms

FlySpeed SQL Query Comments

Cannot set "SET @var :=" in sql text queries

Comment by nineoclick
about FlySpeed SQL Query and MySQL-Front · Nov 2014 ·

There's only a little problem with FlySpeed. It does not have a SQL Editor where you can type something like this simple query:

-- example query --
SET @a := 1;
SELECT @a;
-- ends example query --

I like this app because it has a query builder more stable than MySql-Front (another great alternative I will add later).
So I'll use MySql-Front again in the future for its SQL Editor in which you can write vars and see directly your query results.

When FlySpeed will provide this feature, my thumbs will up.

[Edited by nineoclick, November 19]

We will change this in one of the upcoming versions. For now you can hold the Ctrl while clicking the Execute button or just press the Cttrl+F5 keys to execute such scripts.

Thank you for the tips!

Reply

Runs on Linux using Wine

about FlySpeed SQL Query · ·

Great Program.
Runs on Linux using WINE.
Drivers for MS SQL server are a little more complicated.

Reply

Good for MS Access and MySQL

I like that this tool can work with MS Access and MySQL databases without any client software installed. I mean that you don't have to install MS Access itself or MySQL connector to work with these databases. I have a great experiance in SQL, so I dont need the Visual Query Builder to edit my queries, but I noticed that it is convenient to analyze the existing queries.

Reply