mos wrote:
I have a simple query in MySQL 5.0.24:
insert into table1 (col1) select distinct col1 from bigtable;
that will run for 1:14:18. Both tables are MyISAM and table1 was just
created with 2 columns and is empty.
The "select distinct col1 from bigtable" takes only 2 minutes to run
Dan Nelson wrote:
In the last episode (Oct 03), Angelo Zanetti said:
I've got a database that has a few thousand rows, I've noticed that
some of the search queries (especially the large ones) are taking
some time. Im looking at adding indexes to my tables in order to
speed u
or updated in the database?
Thanks in advance.
--
--------
Angelo Zanetti
Systems developer
*Telephone:* +27 (021) 469 1052
*Mobile:* +27 (0) 72 441
Thanks guys it worked!!! I really appreciate your help.
this is the one that worked:
SELECT u.UserID
FROM Users u
LEFT JOIN BuddyList bl
ON u.userID = bl.buddyID AND bl.userID = '$userid'
WHERE u.isactive =1
AND bl.userID is null
and u.UserID != '$userid';
Michael
tom as he is not
listed as a buddy for mike but bob is.
The query is half working but doesnt seem to be working for an
individual user.
thanks to those who have helped so far...
Michael Stassen wrote:
> Angelo Zanetti wrote:
>
>> thanks shawn it seems to be working but i forgot to add
bl ON u.userID = bl.userID
WHERE u.isactive =1 AND u.userid!='$userid' AND bl.userID is null
but this still returns some results that exist in the buddyList table.
[EMAIL PROTECTED] wrote:
>Angelo Zanetti <[EMAIL PROTECTED]> wrote on 06/08/2005 12:06:51 PM:
>
>
>
>>Hi
Hi guys.
I'm having a problem deciding whether a left join is suitable for what i
want to do.
I have two tables
A Users
-userID
-isactive
B BuddyList
-userID
-buddyID
what i want to do is to get all the users from A that don't exist as a
buddyID for a user (buddyList) also the user must be act
--
Angelo Zanetti
Z Logic
www.zlogic.co.za
[c] +27 72 441 3355
[t] +27 21 469 1052
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
try
REPAIR TABLE 'tablename'
Gleb Paharenko wrote:
>Hello.
>
>
>
>REPAIR TABLE ... USE_FRM helps in difficult cases. See:
>
> http://dev.mysql.com/doc/mysql/en/repair-table.html
>
>
>
>
>
>
>
>
>
>
>
>Per Jessen <[EMAIL PROTECTED]> wrote:
>
>
>
>>All,
>>
>>
>
>
>
>>I've got a table wit
