SQL question

[Proximity]

How would I change the first column to change from 17560 to 1 than 17561 to 2 etc

 

[Brad]

How would I change the first column to change from 17560 to 1 than 17561 to 2 etc

You'll have to do it manually.

 

[TesoMayn]

I'm assuming the row's name is ID?

ALTER TABLE `table` DROP `id`;
ALTER TABLE `table` AUTO_INCREMENT=1;
ALTER TABLE `table` ADD `id`int AUTO_INCREMENT;

 

[Brad]

I'm assuming the row's name is ID?

ALTER TABLE `table` DROP `id`;
ALTER TABLE `table` AUTO_INCREMENT=1;
ALTER TABLE `table` ADD `id`int AUTO_INCREMENT;

the code hasn't been inserted, I'm guessing he's adding items to the table which already have that ID. I think he's just being lazy and wants a script to do it for him lol

 

[JayC]

the

The code hasn't been inserted, I'm guessing he's adding items to the table which already have that ID. I think he's just being lazy and wants a script to do it for him lol

From what the looks of it, they deleted the columns instead of truncating the table so it started at ID 17,000 and he just wanted to reset the ID's.

ALTER TABLE `TABLE` AUTO_INCREMENT =1

Make sure you truncate the table next time, not delete.

TRUNCATE TABLE `TABLE`