Re: Delete from mysql table is there a way to....

What exactly does it mean when a table becomes fragmented? How do you know when it's happened and something should be done? All the docs and books talk about how bad it is but I'm still confused on what this is and when it happens. Thanks, -Lisi At 05:00 PM 4/14/02 -0700, Jennifer Downey wrote:

Hi all, Is there a way to delete a record from a mysql table without fragmenting the db? Here is the query I am using and it does a horrible job. Fragment city. ---------------------------------------------------------------------------- ---- if ($quantity == 0) {

    $gone = mysql_query("DELETE FROM {$config["prefix"]}_my_items WHERE

uid={$session["uid"]} AND id = '$item'"); } ---------------------------------------------------------------------------- ---- Thanks Jennifer -- The sleeper has awaken --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php