syntax error in while and end while in mysql

Question

I have an error in while and end while in my code ... here is my code:

SET i = 0;
WHILE i<n DO
INSERT INTO bo_search_engine_scenario (version, mcs, name, factor, tracking_code) 
          SELECT version, mcs, name, factor, tracking_code FROM  bo_search_engine_scenario_temp LIMIT i,1;
END WHILE

Why does it give me while is not valid at this position?

I don't understand what you want to do. SQL Fiddle demo using WHILE. — wchiquito
– wchiquito, Commented Jul 4, 2016 at 13:14
You can't just type any old command anywhere and expect it to work. — Drew
– Drew, Commented Jul 4, 2016 at 14:49

SArnab · Accepted Answer · 2016-07-04 12:47:04Z

3

You cannot use a while loop outside of a stored procedure.

https://dev.mysql.com/doc/refman/5.7/en/while.html

There is an example on the documentation. A quick Google search will also give you plenty of information on stored procedures.

answered Jul 4, 2016 at 12:47

SArnab

5853 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

la2 la2 Over a year ago

also i tried now using procedure and the same errors appear

SArnab Over a year ago

Can you please post the procedure you attempted

David Duman Over a year ago

That is a stupid restriction! I was trying to test something in a regular query window; I should not have to create a dummy proc first to testing something.

Collectives™ on Stack Overflow

syntax error in while and end while in mysql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related