Take the autoincrement ID from Database and call as default number

[shebbycs]

 

This my id format bigint and auto increment 

 

For example I want to call from database how can i make the ID number start from 1 and finish according to number of available data?

[trq]

Pardon?

[shebbycs]

Pardon?

 

The picture show one of my field that is ID(Auto Increment) Format(BIGINT)

 

My main question is if I want to retrieve the ID as it was from database, I want the ID to be arrange from first number 

 

because the number was 116,117 and 118 and I want it start from 1

Edited April 6, 2013 by shebbycs

[trq]

My main question is if I want to retrieve the ID as it was from database, I want the ID to be arrange from first number

 

because the number was 116,117 and 118 and I want it start from 1

That is not a question.

[l0gic]

I have to say it:

 

$id = $id-115;

 

Enjoy.. Everyone, enjoy.

[Jessica]

You shouldn't change the ID.

[jcbones]

I'm with Jessica on this one.  If you find the need to change the ID, then your design needs work.  There is no reason to change the ID, as then you can/will corrupt the data protocols, especially if that table is tied to other tables through the PRIMARY KEY.

[gizmola]

I'm guessing that the question is: how do you reset the auto_increment id for a table back to 1?

 

This will only work if all the rows are removed from the table, either with DELETE or TRUNCATE table.

ALTER TABLE yourtable AUTO_INCREMENT = 1;

To accomplish this with renumbering, you can select into a temp table and then reinsert, omitting the old id column.

CREATE TABLE t_yourtable AS SELECT * FROM yourtable;
TRUNCATE TABLE yourtable;
ALTER TABLE yourtable AUTO_INCREMENT = 1;
INSERT INTO yourtable (col2, col3... etc) SELECT col2, col3... etc FROM t_yourtable;

*Note* I think that truncate table may set the auto_increment back to 1, but test it with our version just to be sure.

[trq]

I'm guessing that the question is: how do you reset the auto_increment id for a table back to 1?

Why guess? I'm trying to get the op to ask a decent question. This thread is a joke.

[gizmola]

Why guess? I'm trying to get the op to ask a decent question. This thread is a joke.

Good point Tony.

[shebbycs]

Why guess? I'm trying to get the op to ask a decent question. This thread is a joke.

 

Sincerely my english so bad and I am not very fluent in english

[shebbycs]

trq and gizmola sir let me describe in detail based on below picture

 

 

This is my field and the branch_codename is location and I had 23 location and for testing I just put 2 location only

 

Let say if the ID number from table above was arrange from 1 so there will be 1 -5 number and my search query will be where branch_codename='TK02'

 

for sure it will return ID number 2 and 4

 

My main question was if I call the location and using html table I want the number sorting back to 1 and 2  instead of 2 and 4

 

How to do that please

Edited April 9, 2013 by shebbycs

[gizmola]

You need to do that in your procedural code. When you get the result set, you can use a variable and as you fetch each row you increment that counter variable. It is not something you do in SQL or in trying to manipulate your query results.