SingleStore Studio SQL Editor

The Studio SQL Editor page is a feature of Studio that allows customers to edit and run and SQL queries against their SingleStore clusters.

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.

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 ;