How Can Make Loop To Insert Number

Question

0.00/5 (No votes)

See more:

I Need Insert Number 4555 +
0001
0002
0003
0004
0005
0006
0007

and The Result :
45550001
45550002
45550003
45550004
45550005
45550006
45550007

Like
insert Into CodeTbl (num)
values (4555+0001,2,3,4,5,6,7)

and The Result From Select Statement is :
select * from CodeTbl

45550001
45550002
45550003
45550004
45550005
45550006
45550007

How CAN Make Loop To Do that .v

Posted 10-Oct-15 23:34pm

Member 11280947

Add a Solution

Comments

phil.o 11-Oct-15 5:42am

You do realize that 45550001 is not 4555 + 0001 but 45550000 + 1, don't you?

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)

Garth J Lancaster · Answer 1 · 2015-10-10T23:42:00

Solution 1

Maybe you need something like

SQL

Update CodeTbl set num = "4555"||num;

Some Sql/DB Engines need a 'where' clause - so you could do

SQL

Update CodeTbl set num = "4555"||num where num not null;

you didnt say what SQL you're using but thats the general idea ....

|| in some SQL means Concat ..the other assumption Im making, since you dont mention it, is that 'num' is actually a string as shown in your representation

Posted 10-Oct-15 23:42pm

Garth J Lancaster

Updated 10-Oct-15 23:44pm

v2

Comments

Member 11280947 11-Oct-15 5:54am

i Don't Understand This :
Update CodeTbl set num = "4555"||num where num not null;

Garth J Lancaster 11-Oct-15 7:18am

what dont you understand ? do you or do you not have any numbers at all in your table ? we can only help you if you provide useful information. What is the table definition ?, what sql database are you using ?

Member 11280947 13-Oct-15 3:02am

Insert From
155460001
155460002
155460003
155460004
155460005

I Need Loop To Do That