The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Due to deletes and adds, the record id in one of my tables now starts at 2 and ends at 453. I think there are 449 physical records in the table.
How do I resync the index (reindex it)?
Neil
How do I resync the index (reindex it)?
Neil
Good point.
I'm a MySQL newbie(ish).
N.
I'm a MySQL newbie(ish).
N.
can always do
select count(id) from mytable
select count(id) from mytable
Well the (table) record id in the site is a quick way of seeing how many physical records (tunes) I have listed.
I'm selling my vinyl.
N.
I'm selling my vinyl.
N.
All you can do is create specific queries to remove the gaps. eg "update mytable set id=id-1" and so on. Of course if the id is used in other tables, you risk breaking relationships by doing so.
So it does beg the question, why you care about it.
So it does beg the question, why you care about it.
Due to deletes and adds, the record id in one of my tables now starts at 2 and ends at 453. I think there are 449 physical records in the table.
How do I resync the index (reindex it)?
Neil
How do I resync the index (reindex it)?
Neil