MySql while insert loop

Question

0.00/5 (No votes)

See more:

Greetings, I have a problem with the following code >>

SQL

DELIMITER $$

DROP PROCEDURE IF EXISTS insert_ten_rows $$

CREATE PROCEDURE insert_ell_rows ()
BEGIN
DECLARE crs INT DEFAULT 0;

WHILE crs < 11 DO
SET crs = crs + 1;
Insert into events Values(`img\air_show\air (`+crs`).jpg`,`Air Show`,`Air Base`,`0`);
END WHILE;
END $$

My problem is a syntax issue, I'm not sure if it's because of " `img\air_show\air (`+crs`).jpg` " but may you please aid in how I can better tackle this problem. Thank you so much in advance

Posted 23-Jan-14 10:53am

wax-911

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ron Beyer · Accepted Answer · 2014-01-23T10:55:00

Solution 1

Actually I think your problem is the single quotes. You are using the ` character when you should be using the ' one.

SQL

Insert into events Values('img\air_show\air (' + crs + ').jpg','Air Show','Air Base','0');

Try that.

Posted 23-Jan-14 10:55am

Ron Beyer

Updated 23-Jan-14 10:57am

v3

Comments

wax-911 24-Jan-14 1:10am

Thank you so much, I don't know what I was thinking and somehow the $$ were also causing some problems and when I call insert_ten_rows(); it runs through the loop perfectly but one of the columns with 'img\air_show\air (' + crs + ').jpg' returns only the variable 1-10 without any concatenation