Hello MySQL List,
Thanks Ken and HongKong0888 for the advice and suggestions.
I hate when these kinds of problems just "fade away" with no
resolution or analysis of the resolved issue. So, with that,
here is the explanation for what caused THIS particular
problem (can you say user error?).
In re
The documentation says it requires SUPER.
I am aware that it is not the greatest idea to give this priv to users, but
I would really like them to be able to do stop logging for some seesions
Olaf
On 2/3/08 10:03 PM, "Moon's Father" <[EMAIL PROTECTED]> wrote:
> will it be file or super?
>
> On
Hi,
On Feb 4, 2008 11:36 AM, Artifex Maximus <[EMAIL PROTECTED]> wrote:
> Hello!
>
> I am looking for an easy solution for eliminate duplicates but on a row level.
>
> I am having 2 tables. 1 destination for all not duplicated info (a)
> and 1 for input table (b) which might have duplicates relate
Hello!
I am looking for an easy solution for eliminate duplicates but on a row level.
I am having 2 tables. 1 destination for all not duplicated info (a)
and 1 for input table (b) which might have duplicates related to table
a. Now I am using this kind of insert:
INSERT INTO a
SELECT fields
FROM
SELECT FOR UPDATE
On Feb 4, 2008 4:58 PM, Frederic Belleudy <[EMAIL PROTECTED]> wrote:
> Hi there, I'm new with innodb and I'm not sure it's good to go with
> innodb for my personnal goals.
>
> Ok, let's assume I 've a table and want to select the first 10 rows from
> that table but I want to
Hi there, I'm new with innodb and I'm not sure it's good to go with
innodb for my personnal goals.
Ok, let's assume I 've a table and want to select the first 10 rows from
that table but I want to be sure that no other scripts will select the
same rows I've previously got by the first script.
Having a bit of trouble deleting 8645 duplicate rows...
#//mySQL is broken and you can't reference a table you're deleting from in a
subselect.
#//http://www.thescripts.com/forum/thread490831.html
#// you can't even update said table, so this elegant solution fails too...
#// update buglog set BI
Daevid Vincent wrote:
DROP TABLE IF EXISTS `dupes`;
CREATE TEMPORARY TABLE dupes
SELECT LogID FROM buglog GROUP BY BID, TS HAVING count(*) > 1 ORDER
BY BID;
LOCK TABLES buglog WRITE;
SELECT * FROM buglog WHERE LogID IN (SELECT LogID FROM dupes) LIMIT 10;
#DELETE FROM buglog WHERE LogID IN (S
Hi All
I looking for the stated functions. Earlier I was using postGIS in that
they are present i am wondering if I can get similar kind of method in
MySql.I am Using Mysql 5.0.51a version.
1. I am trying to retrieve the distance between two geometries in the
table using the following synta
