MySQL Forums
Forum List  »  Newbie

Re: Repeat query MySQL
Posted by: Peter Brawley
Date: April 24, 2018 10:21AM

Control flow constructs are available only in stored routines. If you're going that way, you'll need to add a room number counter to your loop.

If you're using 8.0, you could write a CTE, you may be familiar with them from SQL Server.

Or most simply, use a text editor to makes 300 copies of your Insert statement, then paste it into the mysql client.

Options: ReplyQuote


Subject
Written By
Posted
April 24, 2018 08:42AM
Re: Repeat query MySQL
April 24, 2018 10:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.