Re: reindex primary key autoincrement at mysql

In article <p2535n$v74$1_at_news.icm.edu.pl>, Jakub <jak74_at_interia.pl> wrote:
> Welcome
>
> How to re index primary key autoincrement column at big table in mysql
> / mariadb ?
>
> greeting Jakub

Hi Jakub,

Why do you want to do that? What problem are you trying to solve?

Do any other tables have a column pointing to that key as a foreign key?

It is possible, but would normally involve copying the table to another new table and then renaming them. But there is not usually any reason to do so, which is why I asked the above questions. There may be a better solution.

Cheers
Tony

-- 
Tony Mountifield
Work: tony_at_softins.co.uk - http://www.softins.co.uk
Play: tony_at_mountifield.org - http://tony.mountifield.org