/SQL/While mysql

While mysql

While mysql

CREATE PROCEDURE dowhile()
BEGIN
  DECLARE v1 INT DEFAULT 5;

  WHILE v1 > 0 DO
    ...
    SET v1 = v1 - 1;
  END WHILE;
END;

0

Source: dev.mysql.com

While mysql

[begin_label:] WHILE search_condition DO
    statement_list
END WHILE [end_label]

0

Source: dev.mysql.com

Similar codes

13 votes211 views3 answers
Sql select from multiple tables without join
SQL
0 vote191 views1 answer
Mql5 list all available symbols
SQL
6 votes214 views1 answer
Postgresql add enum value
SQL
0 vote206 views3 answers
Get count of null in column sql
SQL
4 votes206 views2 answers
Mysql how to change default charset
SQL
1 vote214 views1 answer
Oracle duration between timestamps
SQL
1 vote223 views1 answer
Delete specific row in sql
SQL
0 vote216 views1 answer
Codigo crear tablas sql server
SQL
0 vote205 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
-1 vote205 views2 answers
Full join sql
SQL

Share