BEGIN
  DECLARE varname CHAR(61);
  SET varname = 'Test name';
  MESSAGE varname;
END

BEGIN
   DECLARE v1 INT = 5;
   DECLARE v2, v3 CHAR(10) = 'abc';
			// ...
END

CREATE PROCEDURE HighSales (IN cutoff INT, OUT HighValues INT)
BEGIN
   DECLARE err_notfound EXCEPTION FOR
      SQLSTATE '02000';
   DECLARE curThisCust CURSOR FOR
      SELECT CAST( sum( SalesOrderItems.Quantity *
            Products.UnitPrice ) AS INTEGER) VALUE
      FROM Customers
            LEFT OUTER JOIN SalesOrders
            LEFT OUTER JOIN SalesOrderItems
            LEFT OUTER JOIN Products
      GROUP BY CompanyName;
   DECLARE ThisValue INT;
   SET HighValues = 0;
   OPEN curThisCust;
   CustomerLoop:
   LOOP
      FETCH NEXT curThisCust
         INTO ThisValue;
      IF SQLSTATE = err_notfound THEN
         LEAVE CustomerLoop;
      END IF;
      IF ThisValue > cutoff THEN
         SET HighValues = HighValues + ThisValue;
      END IF;
END LOOP CustomerLoop;
   CLOSE curThisCust;
END;

BEGIN
   DECLARE err_div_by_0 EXCEPTION FOR
      SQLSTATE '22012';
   DECLARE curQuantity CURSOR FOR
      SELECT Quantity
      FROM SalesOrderItems
      WHERE ProductID = 300;
   DECLARE Quantities INT;
   DECLARE altogether INT;
   SET Quantities = 0;
   SET altogether = 0;
   OPEN curQuantity;
   LOOP
      FETCH NEXT curQuantity
         INTO Quantities;
      IF SQLSTATE = '02000' THEN
         SIGNAL err_div_by_0;
      END IF;
      SET altogether = altogether + Quantities;
   END LOOP;
EXCEPTION
   WHEN err_div_by_0 THEN
	CLOSE curQuantity;
	SELECT altogether;
    return;
   WHEN OTHERS THEN
	RESIGNAL;
END;