/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 vote315 views1 answer
Avg mysql
SQL
0 vote293 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote270 views1 answer
How to check replication lag in mySQL
SQL
12 votes282 views2 answers
Delete all data in neo4j
SQL
2 votes294 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote285 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
2 votes299 views2 answers
Mysql user access to database
SQL
0 vote280 views1 answer
Oracle sqlp update amount / quantity
SQL
3 votes304 views2 answers
Postgres show table schema
SQL
1 vote286 views2 answers
Populate sql table with random data
SQL

Share