FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


[mysql] compacting databases





thnn
if i compact a database will it reorder the id field that is auto_increment?
Thanks for any help
shalmoli
It wont reorder the auto_increment field.
However, you should not have script depending on the number of rows in your db. E.g. you delete row no. 42 (auto_increment value and hence the id - 42) . id 43 would be then row no 42. If your script is based on calcultating the number of rows and adding one to it, the script would fail to deliver the required results.
Related topics
Help me to Import mysql databases from web into home pc !
Cron Jobs (AutoBackup for all MYSQL databases every 24h)
protecting mysql databases from sql injection attacks
MySql Databases
Database Privilege
Creating something?
How to import mysql databases from text files?
connect to different mysql databases site.
Website login?
Installing forums in your site
Can't create or alter name of MySQL databases
mysql databases
How do i...
Php mysql and stuff
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.