Picture a Church, full of pews. This is your empty table. As people (your
data) come in to the church they fill the pews but unlike real life the
first person goes all the way to the left hand side of the first pew, the
second sits next to them and the third... When one pew is full they start
Thanks for the explanation! Very clear.
How do you know how fragmented your DB is? I apologize if this is covered
somewhere, like I said I was very confused buy this whole topic.
Thanks,
-Lisi
At 01:00 PM 4/16/02 -0700, Frank Flynn wrote:
Picture a Church, full of pews. This is your
://www.mysql.com/doc/m/y/myisamchk_syntax.html
and
http://www.mysql.com/doc/C/H/CHECK_TABLE.html
for more info..
Gurhan
-Original Message-
From: Lisi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 5:35 PM
To: Frank Flynn; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB
On 4/16/02 2:34 PM, Lisi [EMAIL PROTECTED] wrote:
Thanks for the explanation! Very clear.
How do you know how fragmented your DB is? I apologize if this is covered
somewhere, like I said I was very confused buy this whole topic.
Thanks,
-Lisi
Oh, sorry each database is different but
your posts are here.
i don't think you could do this in other way.
if is possible i'm curios about it too.
Jennifer Downey a écrit :
Hi all,
I'm not sure if my first post showed up so I am going to post it again and I
apologize if it shows up twice.
Is there a way to delete a record from
On Monday 15 April 2002 08:46, Jennifer Downey wrote:
Hi all,
I'm not sure if my first post showed up so I am going to post it again and
I apologize if it shows up twice.
The first post did show up. This is purely a MySQL issue.
Is there a way to delete a record from a mysql table without
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
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 =
Hi all,
I'm not sure if my first post showed up so I am going to post it again and I
apologize if it shows up twice.
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)
{
the WHERE clause? That is, if temp
has multiple rows, which
row in temp would MYSQL check against to determine
prod_id?
-Original Message-
From: Adv. Systems Design
[mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 2:43 PM
To: PHP List
Subject: [PHP-DB
sorry if this is painfully obvious but I can't seem to
figure it out...It seems to me (unless I am reading it
waay wrong) that the mysql DELETE command does NOT
allow you to refer to columns from other tables!
I have identified certain records to be deleted from 3
tables and created a temp
: Friday, February 01, 2002 2:43 PM
To: PHP List
Subject: [PHP-DB] DELETE in mysql?
sorry if this is painfully obvious but I can't seem to
figure it out...It seems to me (unless I am reading it
waay wrong) that the mysql DELETE command does NOT
allow you to refer to columns from other tables!
I
-
From: Adv. Systems Design
[mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 2:43 PM
To: PHP List
Subject: [PHP-DB] DELETE in mysql?
sorry if this is painfully obvious but I can't seem
to
figure it out...It seems to me (unless I am reading
it
waay wrong
13 matches
Mail list logo