Hello.
Did you read all promptings at:
http://dev.mysql.com/doc/mysql/en/Full_table.html
"Manish" <[EMAIL PROTECTED]> wrote:
> I am trying to execute this query and it is failing with Table is full error
> (I know I can make temp tables big).
> update t1, t2
> set t1.XXX=1
> where t
I am trying to execute this query and it is failing with Table is full error
(I know I can make temp tables big).
update t1, t2
set t1.XXX=1
where t1.YYY=t2. and t2. like '%X%';
My t1 has 10,00,000+ records and t2 has about 70,000 records. I would like
to know how can I optimize this query
UPDATE some_table SET some_field=IF(id = some_id,1,0)
Have fun,
Stephen
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 21, 2003 11:41 AM
Subject: Update optimization?
Hello guys,
Let say:
UPDATE some_table SET some_fiel
TED]>
Sent: Thursday, November 20, 2003 6:39 PM
Subject: UPDATE optimization?
Hello guys,
Let say:
UPDATE some_table SET some_field=1 WHERE id = some_id
and
UPDATE some_table SET some_field=0 WHERE id <> some_id
what I can do to merge these queries?
The first thing that came up in my mind w
Hello guys,
Let say:
UPDATE some_table SET some_field=1 WHERE id = some_id
and
UPDATE some_table SET some_field=0 WHERE id <> some_id
what I can do to merge these queries?
The first thing that came up in my mind was something like that:
UPDATE some_table SET some_field=1 WHERE id = some_id; SET
Hello guys,
Let say:
UPDATE some_table SET some_field=1 WHERE id = some_id
and
UPDATE some_table SET some_field=0 WHERE id <> some_id
what I can do to merge these queries?
The first thing that came up in my mind was something like that:
UPDATE some_table SET some_field=1 WHERE id = some_id; SET
