Query Builder

The query builder is a graphical way of building queires. The table name and column name are uploaded into a format in which you can select which fields you want to manipulate. The query builder is usefull as a starting point to create queires. For more complicated queires, the normal editor should be the preferred choice.

Select Builder

There are three parts of creating a select statement with the select query builder. First is the fields to display in the select section. You can either add a column to select, add all, or use the default which is a star select. Second is the alias of the table in the table section. The default is to not use an alias but if an alias is used, the corresponding fields will update to use the alias. Third is the where clause in the where section. There are four parts to each clause in the where section: the left field , the relationship, the value, and the conjunction.

If none of these fields are selected, then the query generated will be of the form "SELECT * FROM <table selected>". All the sections are editable, even the drop downs.

The Select Query Builder

The Generated SQL

Update Builder

The update builder is similar to the select builder except there is a set section instead of a select section. You can specify the values for each of the columns in the set section and they will be inputed as values in a prepared statement.

The Update Query Builder

The Generated SQL

Insert Builder

The insert builder has only one section and that is to specify the values of the new row.

The Insert Query Builder

The Generated SQL

INSERT INTO
    mysql.user
(
    Host,
    User,
    Password,
    Select_priv,
    Insert_priv,
    Update_priv,
    Delete_priv,
    Create_priv,
    Drop_priv,
    Reload_priv,
    Shutdown_priv,
    Process_priv,
    File_priv,
    Grant_priv,
    References_priv,
    Index_priv,
    Alter_priv,
    Show_db_priv,
    Super_priv,
    Create_tmp_table_priv,
    Lock_tables_priv,
    Execute_priv,
    Repl_slave_priv,
    Repl_client_priv,
    Create_view_priv,
    Show_view_priv,
    Create_routine_priv,
    Alter_routine_priv,
    Create_user_priv,
    ssl_type,
    ssl_cipher,
    x509_issuer,
    x509_subject,
    max_questions,
    max_updates,
    max_connections,
    max_user_connections
) VALUES (
    ?,  -- Host
    ?,  -- User
    ?,  -- Password
    ?,  -- Select_priv
    ?,  -- Insert_priv
    ?,  -- Update_priv
    ?,  -- Delete_priv
    ?,  -- Create_priv
    ?,  -- Drop_priv
    ?,  -- Reload_priv
    ?,  -- Shutdown_priv
    ?,  -- Process_priv
    ?,  -- File_priv
    ?,  -- Grant_priv
    ?,  -- References_priv
    ?,  -- Index_priv
    ?,  -- Alter_priv
    ?,  -- Show_db_priv
    ?,  -- Super_priv
    ?,  -- Create_tmp_table_priv
    ?,  -- Lock_tables_priv
    ?,  -- Execute_priv
    ?,  -- Repl_slave_priv
    ?,  -- Repl_client_priv
    ?,  -- Create_view_priv
    ?,  -- Show_view_priv
    ?,  -- Create_routine_priv
    ?,  -- Alter_routine_priv
    ?,  -- Create_user_priv
    ?,  -- ssl_type
    ?,  -- ssl_cipher
    ?,  -- x509_issuer
    ?,  -- x509_subject
    ?,  -- max_questions
    ?,  -- max_updates
    ?,  -- max_connections
    ?   -- max_user_connections
)

Delete Builder

The delete query builder allows you to create a delete statement and prerun it as a select statement to see which rows you are actually deleting.

The Delete Query Builder

The Generated SQL
SourceForge.net Logo