Open and Save

Saving to a SQL file

Saving to a SQL file will save all the SQL statements into one file. To save to a SQL file press CONTROL+S or go to FILE->Save Sql File. When SuperQuaiL save a query, information about the query is stated as SQL comments. Each SQL statement will start with the comment --Sql Begin, and then other information follows. At the end is the actual SQL statement. Then the next SQL statement is entered.
-- Sql Begin:pn_phpbb_users
SELECT
    *
FROM
    phoenix.pn_phpbb_users;

-- Sql Begin:pn_user_property
-- Param:String,8
SELECT
    *
FROM
    phoenix.pn_user_property
WHERE
    pn_prop_id < ?;

Opening a SQL file

Opening a SQL file will open each SQL statement into its own tab. To open a SQL file press CONTROL+O or go to File->Open SqlFile. If the SQL file was save by SuperQuaiL then tab information about the query is also uploaded.

SourceForge.net Logo