The Nice Spider wrote:
> Hi,
>
> This query running fine on 4.0.25 but when trying on
> 3.23 an error occurs.
> can one help me to find correct command for 3.23?
>
> DELETE FROM A
> USING A
> RIGHT JOIN B ON B.id = A.sectionid
> WHERE B.id is null
>
> This task is deleted any row in A that have no
On Sat, May 06, 2006 at 12:55:55PM +0100, Peter Rosenthal wrote:
> Out of interest is there any time on the roadmap to improve the query
> optimizer's handling of sub-queries as specified in
> http://dev.mysql.com/doc/refman/5.0/en/subquery-restrictions.html ?
As Timour previewed at his "Speeding
That's not a bug, that's a missing feature (or we can call it
unoptimal behaviour).
I think that having 1 databases and 1 users on a single mysqld
and doing "show databases" query often isn't what developers see as
intended usage for MySQL. :)
Here's what happens when you do "show databa
> I know it a 4.1... But as I compiled it my self it is not so easy to figure
> it out And it might take a while to trial-n-error all 4.1.x
You should be able to see from the change log / version history pages in the
manual which minor version releases introduced incompatible changes to the
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> What is happening is that when you start you perl script which
> contains a lot of queries, you are first establishing a connection to
> MySQL, and then you are running some queries, and somewhere in between
> you are losing connection to the server,
Hello sheeri,
Friday, May 5, 2006, 9:25:18 PM, you wrote:
sk> You're comparing apples to oranges -- your where clauses are
sk> different. The first query uses the primary key because you're
sk> actually comparing 'account' to something. The second query doesn't
sk> because you're using the 'str
Quoting sheeri kritzer ([EMAIL PROTECTED]):
> Do a "show status like 'uptime'" after the script runs. See if the
> server crashed (if so, uptime will be low) -- if the server crashed
> you might get that error.
The server itself does not crash. Uptime shows that, besides the fact
that this would
Out of interest is there any time on the roadmap to improve the query
optimizer's handling of sub-queries as specified in
http://dev.mysql.com/doc/refman/5.0/en/subquery-restrictions.html ?
Thanks.
On Fri, 2006-05-05 at 15:39 -0500, Duzenbury, Rich wrote:
> [mysql.server]
> use-manager
>
> [manager]
> socket=/tmp/manager.sock
> pid-file=/tmp/manager.pid
> monitoring-interval=30
You don't have log option specified here. Try adding
log=/var/lib/mysql/mysqlmanager.log
Petr
--
MySQL General
