/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 vote177 views1 answer
Add computed column to table sql server
SQL
0 vote175 views1 answer
Get the previous column of a table in mysql
SQL
0 vote178 views1 answer
Java mysql swing example
SQL
0 vote165 views1 answer
Object Information
SQL
0 vote185 views1 answer
Tsql find procedure with name
SQL
0 vote175 views1 answer
Multiple tricky query in sql server
SQL
0 vote178 views1 answer
Mysql select statement after index
SQL
8 votes191 views3 answers
SQL column name
SQL
5 votes175 views3 answers
Oracle list columns in schema
SQL
1 vote169 views2 answers
End mysql command
SQL

Share