The top pane of the Analyze Query window enables you to type the text of SQL query statements and perform various operations such as statement execution and syntax checking.

If you enter multiple queries, they should be separated by a delimiter. By default, this is the semicolon (;). If any query must contain a semicolon that is not part of a quoted string (such as in create procedure statements), you can change the delimiter by entering the following command:

delimiter <delimiter character>

For any subsequent input in the query panel, the specified delimiter character is used. Once you execute or prepare the contents of the query panel, the delimiter reverts to the semicolon. For example:

insert into mytable values (1, 'abc');
select * from mytable;
delimiter $
create procedure myproc(param1 in numberic (6))
begin
declare localvar integer;
end$
select id from mytable$

The queries are executed sequentially and the results of each are shown in a separate result pane. If an error occurs during the processing of one of the queries, none of the queries that appear after that one is executed.

You can indicate that a typed query should be ignored by placing two hyphens (--) at the start of the query. Selected text can be commented out by surrounding the text to be omitted with /* and */. You can also load queries from a text file into the text pane.