want to insert 1 to 9999 into ID column

Question

0.00/5 (No votes)

See more:

MySQL

hi,

for my application in a table called Mytable having ID column.

i want to insert 1 to 9999 into that ID column

Posted 20-Oct-12 2:41am

sk. maqdoom ali

Add a Solution

Comments

Thomas Daniels 20-Oct-12 8:46am

Ok, so do that.
Where you're stuck?

OriginalGriff 20-Oct-12 10:05am

Where are you stuck, and (more to the point) why do you want to do this?
Just setting the ID column for 9999 rows doesn't do much that is useful, unless there is other data involved.

Sandeep Mewara 20-Oct-12 13:42pm

And the issue is?

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)

Yvan Rodrigues · Answer 1 · 2012-10-20T06:38:00

You would need to define and execute a stored procedure (assuming you want to do this on the server, not the client).

If id is AUTOINCREMENT

SQL

CREATE PROCEDURE initiaize_id()
BEGIN
  DECLARE v1 INT DEFAULT 0;

  WHILE v1 < 10000 0 DO
    INSERT INTO MyTable (id) VALUES (null);
    SET v1 = v1 + 1;
  END WHILE;
END;

otherwise

SQL

CREATE PROCEDURE initiaize_id()
BEGIN
  DECLARE v1 INT DEFAULT 0;

  WHILE v1 < 10000 0 DO
    INSERT INTO MyTable (id) VALUES (v1);
    SET v1 = v1 + 1;
  END WHILE;
END;