Dear MySQL'ers,
Any chance that MySQL for OS X 10.4 64 bit will be updated to 5.0.37?
It's still at 5.0.27.
Thanks,
Jan Pieter Kunst
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
from 5.0.27 till now 5.0.37, porblem still like this:
select * from a1,a2
left join b1 on b1.f1=a1.f1
where a2.f2=a1.f2
// shows table a1 does not exist.
if SQL changes into
select * from a2,a1
left join b1 on b1.f1=a1.f1
where a2.f2=a1.f2
// SQL
Ow Mun Heng,
If you reduce your algorithm to a fromula, I think you'll find it's
algebraically equivalent to the formula you quote.
PB
Ow Mun Heng wrote:
Hi,
I'm looking at creating some aggregrate table based on ~2hr pull from
the main DB and looking to get standard stuffs like min/max/av
Hi,
I'm looking at creating some aggregrate table based on ~2hr pull from
the main DB and looking to get standard stuffs like min/max/ave etc.
I'm having some issues with getting stdev which would be representative
of the stdev of say 10 hours of data.
>From this website : (it references using S
Ian Collins a écrit :
> Hi,
> I have a HP rp3410 with 4Gb RAM running HPUX 11.11. This is running,
>
> Version: '5.0.26-pro-log' socket: '/tmp/mysql.sock' port: 3306 MySQL
> Pro (Commercial)
>
> When this machine is put under load (i.e, a lot of database activity),
> the clients are receiving
Richard Cooper a écrit :
> Hi,
>
> I have a MySql database running on version 5.0.27 which every few days
> for no reason I can fathom stops letting me log in.
>
> mysql -u username dbname -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'username'@'localhost'
> (usi
Mahmoud Badreddine wrote:
Hello to all
I had an old MySQL 4.0 running on a Windows Machine.
I removed that version and I installed the MySQL 5.0 .
When I went to run phpMyAdmin this is the error I receive.
#1251 - Client does not support authentication protocol requested by
server;
consider up
Hello to all
I had an old MySQL 4.0 running on a Windows Machine.
I removed that version and I installed the MySQL 5.0 .
When I went to run phpMyAdmin this is the error I receive.
#1251 - Client does not support authentication protocol requested by server;
consider upgrading MySQL client
Althou
Then you just have to come up with some other criteria for determining who
should be counted as "before" or "after" Joe, which might well be the same
as the order by clause in whatever you're doing right now while examining
the result set.
I think your approach of examining the result set will wo
I have noticed that when using the C API that in certain instances
the field 'type' constant is not correct.
When a value is returned from a 'TEXT' type field it is reported as a
'BLOB' type. I realize that a TEXT is an extension of a BLOB, but,
since they are different types according to
That is a nice idea, I'll have to keep it in my bag of tricks.
However, I don't know if it will work b/c there are probably others
that are hired on the same date...
On Apr 4, 2007, at 1:51 PM, Dan Buettner wrote:
James, one option would be to run a query to find the number of
people in
th
Ok, sorry. When I described the initial scenario it wasn't exactly
accurate. I want to find Joe in the list of everyone hired on the
same date as Joe.
So when I do my query,something to the effect of:
select from users where hiring_date=$target_date ORDER BY user_uniq_id;
Now the result set
James, one option would be to run a query to find the number of people in
the list ahead of him, rather than determining position within the result
set.
As in:
SELECT COUNT(*) FROM some_table
WHERE state = "Maine"
AND hire_date < (SELECT hire_date FROM some_table
WHERE last_name = "Smith"
AND fi
Many thanks for your input. Looks like the older version of mysql, preceding
5.0 has some problems. I've to upgrade mysql now. :-(
Thanks again.
Mogens Melander <[EMAIL PROTECTED]> wrote:
Well, trying your example gives me the expected result.
select cust.ssn, disposition.disposition, so
That would only work if the result set is sorted by name. You said you
wanted to sort by hiring date, that's not going to work.
As for the general approach, I don't have enough experience to judge. How
big would you expect the result set to be?
Regards,
Jerry Schwartz
Global Information Incorpor
Right now I'm trying to use PHP to do a binary search on the result
set so I don't have to traverse the entire result set.
I'm using PHP's mysql_data_seek() to move the pointer within the
result set and looking at the data.
What do people think of this approach?
-James
On Mar 22, 2007, a
Hi,
I have a MySql database running on version 5.0.27 which every few
days for no reason I can fathom stops letting me log in.
mysql -u username dbname -p
Enter password:
ERROR 1045 (28000): Access denied for user
'username'@'localhost' (using password: YES)
When I log in as
Hi,
I followed the instructions to change columns values from an encoding
another
(in my case from latin1 to utf8), but the operation simply failed.
The manual reads
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html :
"
If you want to change the table default character set and all ch
18 matches
Mail list logo
