var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors