/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

1 vote272 views1 answer
Mysql not supported auth mode
SQL
0 vote279 views1 answer
Mysql grant grant option
SQL
93 votes361 views4 answers
Create database postgres
SQL
0 vote307 views1 answer
Mysql where sum > 0
SQL
15 votes267 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote251 views1 answer
Clone table structure mysql
SQL
0 vote305 views1 answer
Cube oracle
SQL
1 vote263 views1 answer
Search for tables with name postgresql
SQL
10 votes280 views1 answer
Oracle dependencies table
SQL
1 vote294 views2 answers
Snowflake alter column data type
SQL

Share