Build your queries with FlySpeed SQL Query
Flyspeed SQL Query tutorial

Flyspeed SQL Query is a software that allows you to create your SQL queries easily using a graphical user interface. It is published by Active Database Software and is free for personal use.

Flyspeed SQL Query can be very useful in general for building your SQL queries, and especially with PHP CRUD Generator to generate queries to filter your data lists. The software generates queries with joins (LEFT JOIN, INNER JOIN, RIGHT JOIN), allows you to protect terms with backticks (``), and provides many other useful options.

It is very easy to use and can be started in a few minutes: This is what we will see in the following tutorial.

Install FlySpeed SQL Query and connect your database

  1. Download here: FlySpeed SQL Query Download page
  2. Open the installer & install the software on your system
  3. Open FlySpeed SQL Query and click the New Connection button:
    FlySpeed SQL Query New Connection
  4. Choose your database type among those listed in the Connection Wizard
    FlySpeed SQL Query Connection Wizard
  5. Enter your database connection properties and choose the default database, then click next.
    FlySpeed SQL Query Connection properties
  6. The wizard lists all the available databases with the connection parameters you specified in the previous step.
    If you want to use only the default database just click the Next button. Alternatively, you can choose multiple databases and add them to the project by clicking on the Add button.
    FlySpeed SQL Query Choose the default database
  7. Give your connection a name and click Finish to close the wizard and open your new connection.
    FlySpeed SQL Query Name your connection

Build your SQL queries with Flyspeed SQL Query's User Interface

Once you setup your connection you can see all your tables in the left column of the software interface.

  1. Click the New Query button to open the query builder
    FlySpeed SQL Query Query Builder

  2. Drag-and-drop your tables from the left column to the main query builder and check the columns you want to use in your query.
    The SQL query is automatically generated in the main panel.

    The middle panel allows to add criteria, order and group your records, set aliases and many other useful things.
    By clicking on the connecting rows between the different tables, you can change the types of joins.FlySpeed SQL Query Query Builder

You have seen that it is very easy to create your SQL queries with Flyspeed SQL Query.
This quick tutorial is of course not exhaustive, and the Flyspeed software is far more extensive than what is introduced here. Nevertheless, the few features explained above will help you get started quickly, and will even be sufficient for most common uses.

These queries will be very useful for creating advanced filters in PHP CRUD Generator.

Build up your database

PHP CRUD tutorial main page