Important

Self-managed SingleStore will soon transition from version 9.1 RC to version 10. This new semantic versioning scheme will provide SingleStore with finer control over engine and feature releases that were not possible with the current versioning scheme.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10 prior to its general availability. Ahead of this transition, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.

SingleStore Studio SQL Editor

The editor in this page works like a worksheet where users can type in multiple SQL queries and then choose which queries they want to run. By default, Studio will run only one query (whichever one is being highlighted in the editor). However, users can also select more than one query using their mouse cursor in order to run multiple queries sequentially.

Creating and Running a Stored Procedure

In order to create a Stored Procedure in the SQL Editor, simply paste a regular CREATE PROCEDURE block into the editor:

SQL

DELIMITER //
CREATE PROCEDURE charge_account(id BIGINT, amount DECIMAL(18,4)) AS
  DECLARE
    balance_tbl QUERY(bal DECIMAL(18,4)) =
      SELECT remaining_balance
      FROM account_balance
      WHERE account_id = id;
    balance DECIMAL(18,4) = SCALAR(balance_tbl);
    updated_balance DECIMAL(18,4) = balance - amount;
  BEGIN
    IF balance > amount THEN
      UPDATE account_balance
      SET remaining_balance = updated_balance
      WHERE account_id = id;
    END IF;
  END //
DELIMITER ;

Then, you can either select and execute the entire block or simply place the editor cursor anywhere in between the // delimiters and click Run.

Finally, running the stored procedure works like running any query. Simply type CALL charge_account(1, 200.0000); into the SQL Editor and click Run.

SingleStore Studio SQL Editor

On this page

Creating and Running a Stored Procedure

Was this article helpful?

On this page

Was this article helpful?