I am uploading (refreshing) a data file to a table once a week.
I used TRUNCATE rather than LOAD REPLACE because it is supposed to reset the autoincrementer ID.

As it certainly doesn't reset it (now in the billions!) is there a command to reset the ID that I can put in as a query?

"ALTER TABLE table_name AUTO_INCREMENT = 100;"

I've tried this to no effect in a mysql query. Thanks, though!
I must contact my hoster to see why! I presume it should simply change that field throughout the table. Or does something else have to happen first do you think?