each time when i run a program in mysql the coumn should start with 1 and then it should be auto generated

Question

0.00/5 (No votes)

See more:

each time when i run a program in vb.net the column should start with 1 and then it should be auto generated in the table of my sql.
suppose i have a table table1 with fields tab1,tab2,tab3

tab1 tab2 tab3
1      ggg  jjj
2      jjh   kjjk

when i run again the vb.net program all the column to be deleted and the auto generate column tab1 should start with 1.
i cant coz

tab1   tab2   tab3
3      ggg     jjj
4       jjh     kjjk

plz help it should start with

1    ggg     jjj
2    jjj     kjjk

plz help.......................

Posted 7-Jan-12 0:55am

taher ahmed choudhury

Updated 7-Jan-12 1:04am

Mehdi Gholam

v2

Add a Solution

2 solutions

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)

Sridhar Patnayak · Answer 1 · 2012-01-07T01:09:00

Solution 1

I think it is bad database design.

if tab1 is a auto generated column then it should require another column to insert data (current tab1 data)

Otherwise data inconsistency occurred.

Thanks.

Posted 7-Jan-12 1:09am

Sridhar Patnayak

Updated 7-Jan-12 1:10am

v4

Comments

taher ahmed choudhury 7-Jan-12 7:30am

no i am loading in the database successful but the colum which is autogenerated is starting with the last index once after deleting all the columns of the tables through code

Graham Breach · Answer 2 · 2012-01-07T23:43:00

Solution 2

You can use TRUNCATE TABLE to delete all the rows in the table and reset the auto increment value: http://dev.mysql.com/doc/refman/5.5/en/truncate-table.html[^]

Posted 7-Jan-12 23:43pm

Graham Breach