Author Topic: How can I change volume of 'next autoindex' in MySQL for 4images_images tab (Read 7110 times)

V@no · « **on:** October 16, 2002, 05:36:25 AM »

I add and delete many pictures, and now I have 1000+ all together, but image_id increasing from 2000+ already. is there a way to change that number from MySQL command?
I'm using phpMyAdmin to work with MySQL, but there is no way I can fix it if I dont know the command or whatever.
can someone help me?

P.S. I fully understand that this can make a mess.

Jan · « **Reply #1 on:** October 16, 2002, 08:30:49 AM »

No, the only way to reset the auto increament index is to empty the whole table with

Code: [Select]

DELETE FROM [table]

Jan

V@no · « **Reply #2 on:** October 17, 2002, 01:41:52 AM »

omg, sounds not too good...
but thx, Jan.
btw, if so, how many photos I can add? is there a limit like to 65535? hope not, couse I'm getting close to this number! just 63535 more photos and I'm done! hehe

Jan · « **Reply #3 on:** October 17, 2002, 08:20:04 AM »

The limit is 8388607. Hope this is enough

Jan

4images Forum & Community

News:

Author Topic: How can I change volume of 'next autoindex' in MySQL for 4images_images tab (Read 7110 times)

V@no

How can I change volume of 'next autoindex' in MySQL for 4images_images tab

Jan

How can I change volume of 'next autoindex' in MySQL for 4im

V@no

How can I change volume of 'next autoindex' in MySQL for 4im

Jan

How can I change volume of 'next autoindex' in MySQL for 4im