Shawn Green wrote:
> 23. There are fewer and less sophisticated tools for administration.
>
> MySQL doesn't need them. That alone should tell you something about
> our reliability.
>
This speaks to simplicity-- both in terms of easy to use and in terms of
more limited features. It says nothing
tech user wrote:
Add an alias for the subquery
select * from ( select ) my_alias where dd >= 3;
Better, use a having clause and eliminate the subquery. Odds are it
will be more efficient in MySQL.
How to replace the original one with a having statement?
Thanks again.
sele
tech user wrote:
hello,
I try to execute this sql in mysql shell,but got error as:
mysql> select * from (select uin,count(*) as dd from active_users where
date >= date_add(curdate(),interval -30 day) group by uin) where dd >=3;
ERROR 1248 (42000): Every derived table must have its own alias
Ofer Inbar wrote:
It appears to be an article for perl programmers not familiar with
MySQL, warning them of MySQL quirks they should be aware of. If you
write a perl script with DBD::MySQL and try one of the examples he
gave, and check your return status to see if the statement succeeded,
does i
Thomas Raso wrote:
Hi all,
I want to know the main differences between mysql 5.0.41 and MySQL
5.0.51a(last GA release)
I read this page :
http://dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html but there is
nothing about the developments made by such update...
thnaks all...
Try this:
Yes, you can.
Whether there are disadvantages depends mainly on how you are using mysql.
When there are many databases (an order of magnitude or more than what you
propose), some people report that "show databases" can be slow.
Otherwise, the disadvantages are mainly administrative. For examp
And of course just as I send this to a public list, I realize there is also
Ssl_version and Ssl_verify_mode, which seem to be session level counters to
give us the information we are after here. *sheepish*
-Original Message-
From: paul rivers [mailto:[EMAIL PROTECTED]
Sent: Saturday
I've wrestled with the same question. The only options I came up with were:
- Do as you suggest and require SSL for the account.
- Inspect the 'show status' variable of Ssl_accepts after a connection
attempt on an otherwise quiet mysql instance.
- Sniff the traffic between client and server, but
Specify the data dir in the local my.cnf and be sure your instance uses it
by starting it with the --defaults-file parameter set to that instance's
local copy.
Regards,
Paul
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 02, 2006 3:11 PM
To: Dan Buettne
Going from 3 to 5 can break a number of important things. For example, join
syntax semantics and precedence rules have changed since 3, and it is
certainly possible this could break your code in important and dramatic
ways.
You should plan on spending time checking out all the SQL. Just as
i
10 matches
Mail list logo
