/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

0 vote138 views1 answer
Show tables in cassandra cql
SQL
0 vote142 views1 answer
Mysql error 1251
SQL
6 votes136 views1 answer
Oracle desc table primary key
SQL
0 vote139 views1 answer
Sql query wordpress export post
SQL
0 vote134 views1 answer
Postgres statistics
SQL
10 votes137 views2 answers
Sql rtrim
SQL
12 votes148 views6 answers
Change mysql root password
SQL
0 vote186 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
1 vote191 views1 answer
Oracle transaction rollback not working
SQL
-1 vote142 views2 answers
Create temporary table sql
SQL

Share