mysql DECLARE WHILE outside stored procedure how?

by

No, you cannot do it. You can use these statements only inside BEGIN…END clause.

So, it is possible in stored procedures/functions, triggers and events.

More information here – MySQL Compound-Statement Syntax.

More Related Contents:

  1. Why do I get an error from this sub query script?
  2. sql query to modify the selected value from database [closed]
  3. how to get similar search results in MySQL?
  4. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  5. Can I concatenate multiple MySQL rows into one field?
  6. Disable ONLY_FULL_GROUP_BY
  7. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  8. How to do the Recursive SELECT query in MySQL?
  9. MySQL, update multiple tables with one query
  10. How do I see all foreign keys to a table or column?
  11. Do different databases use different name quote?
  12. MySQL case sensitive query [duplicate]
  13. Simulating MySQL’s ORDER BY FIELD() in Postgresql
  14. What does mysql error 1025 (HY000): Error on rename of ‘./foo’ (errorno: 150) mean?
  15. How do I change the data type for a column in MySQL?
  16. mysql fulltext search failure
  17. Adding a leading zero to some values in column in MySQL
  18. Using SQL to determine word count stats of a text field
  19. Update one MySQL table with values from another
  20. MySQL Order before Group by
  21. How to transpose mysql table rows into columns
  22. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  23. Export a MySQL Database to SQLite Database
  24. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  25. How to display open transactions in MySQL
  26. SQL search multiple values in same field
  27. Removing duplicates with unique index
  28. MySQL – Select the last inserted row easiest way
  29. Ruby gem mysql2 install failing [duplicate]
  30. What’s the best way to migrate a Django DB from SQLite to MySQL?

Leave a Comment