/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

4 votes209 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote213 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote180 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
2 votes195 views2 answers
Get all tables using like
SQL
0 vote194 views1 answer
How to make case insensitive in sql
SQL
0 vote212 views2 answers
Postgresql gset
SQL
0 vote226 views1 answer
Mysql config slave
SQL
5 votes175 views2 answers
Oracle list columns schema
SQL
1 vote202 views1 answer
Altrer name column postgres
SQL
1 vote205 views1 answer
Oracle stop
SQL

Share