Performing multiple queries

You can also execute multiple queries at once using the SQL editor in similar fashion to the single query function. Just write down all your queries, separated by a semicolon (;) and press the ‘Query All’ button. Alternatively, you can press the hotkey ‘Ctrl+Shift+Enter’. All queries will be executed one by one in the sequence they are written, and results will be shown in the messages tab, including number of affected records and any errors that are encountered.

Please note that the execution of queries stops as soon as an error occurs. If you would like more advanced batch operations, please use the ‘Batch import’ feature described later in this document.