Am 01.01.2014 23:30, schrieb Elim Qiu:
> I installed mysql 5.1 to windows 7 using mysql-5.1.73-winx64.msi and got
> confused on how to relocate the datadir.
>
> my basedir was F:/MySQL and datadir was F:/MySQL/data
>
> It works fine and I'm trying to relocate the datadir:
>
> (0) stop mysql ser
Hi Jesper
I was just discussing this with the development manager now and the
following was noted.
- The query was written for mysql 4.0 originally and it seems
that in version 5.0 they had enabled some legacy support stuff ( I am
not too familiar with this as it is before my mys
Happiness, that gave me what I was looking for. Thank you Johan.
I have tested the option you gave me but my brackets was in the wrong place.
On 08/11/2013 13:23, Johan De Meersman wrote:
- Original Message -
From: "Machiel Richards"
ERROR 1064 (42000): You have an error in your S
- Original Message -
> From: "Machiel Richards"
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'GROUP BY t.AccountID,
I suspect your query has never been doing what you thi
Hi Machiel,
On 8/11/2013 20:04, Machiel Richards wrote:
Good day all
I am hoping someone can assist me in the following.
One of our servers were running mysql 5.0 still and as part of
a phased upgrade route we have upgraded to version 5.1.
However since the upgrade, t
They are both right. It is a matter of how many decimal places you want to
display:
mysql> SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
my
From: "Alex Keda"
To: mysql@lists.mysql.com;
Sent: 6:37 Piątek 2013-02-15
Subject: MySQL 5.1: incorrect arithmetic calculation
( ... cut ...)
>
> but, my desktop calculator gives the result 548.60
>
1. your desktop calculator is wrong
2. correct result is 548.595, variations (548.59 and 548
- Original Message -
> From: "Alex Keda"
> To: mysql@lists.mysql.com
> Sent: Friday, 15 February, 2013 12:16:18 PM
> Subject: Re: MySQL 5.1: incorrect arithmetic calculation
>
> sorry, I'm too many work... =)
Heh :-) I was thinking, why would that not
15.02.2013 14:43, Johan De Meersman пишет:
- Original Message -
From: "Alex Keda"
mysql> SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EXACTLY 548.595 f
- Original Message -
> From: "Alex Keda"
>
> mysql> SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
> `WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EXACTLY 548.595 for the first
row and 0 for the seco
15.02.2013 15:07, Alex Keda пишет:
OK. But, how about:
mysql> SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
mysql>
??
sorry, I'm too many
At first blush, your problem would appear to concern the lack of index-use.
That's where I would begin my investigation. It might be painstaking, but
I would do something like this:
For each view
Look at the Join(s) and see what columns are being joined
Look at the tables and see what col
Just like that, not advisable. There's upgrade scripts in the packages that
should handle 5.0 to 5.1; but your safest bet is still going to be a clean
mysqldump and import.
- Original Message -
> From: "Brent Clark"
> To: mysql@lists.mysql.com
> Sent: Thursday, 10 March, 2011 2:07:11 PM
On Mon, Mar 16, 2009 at 10:25 AM, Hatem Nassrat wrote:
> Hi,
>
> Is there any way to rollback a transaction in MySQL 5.1 that contains
> "Create", "Alter", "Drop", table statements.
No. Sorry.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Sun, Jan 11, 2009 at 9:31 PM, mos wrote:
> At 03:25 PM 1/11/2009, you wrote:
>>
>> On Sun, Jan 11, 2009 at 2:24 PM, mos wrote:
>> > Yesterday I decided to take the plunge and upgrade from MySQL 5.01 to
>> > 5.1.30
>> > because after all, it was Saturday and what else is there to do on a
>> > S
At 03:25 PM 1/11/2009, you wrote:
On Sun, Jan 11, 2009 at 2:24 PM, mos wrote:
> Yesterday I decided to take the plunge and upgrade from MySQL 5.01 to
5.1.30
> because after all, it was Saturday and what else is there to do on a
> Saturday?
>
> I'm running it on XP Pro with 3gb ram and used the
On Sun, Jan 11, 2009 at 2:24 PM, mos wrote:
> Yesterday I decided to take the plunge and upgrade from MySQL 5.01 to 5.1.30
> because after all, it was Saturday and what else is there to do on a
> Saturday?
>
> I'm running it on XP Pro with 3gb ram and used the my.ini for very large
> system. I dec
Make sure your log_bin_trust_function_creator is on.
On Sun, Sep 28, 2008 at 3:04 AM, Jesse <[EMAIL PROTECTED]> wrote:
> I'm trying to use existing functions from a restored database from 5.0xx to
> 5.1, and get an error about the mysql.proc table is missing or corrupt. The
> mysql.proc table app
Sid Lane wrote:
any update on the 5.1 general release date? is it still on target for
Q4 -
Q1? any narrower window?
Last I heard, Q2 next year.
Regards
--jm
On 8/30/06, Colin Charles <[EMAIL PROTECTED]> wrote:
Logan, David (SST - Adelaide) wrote:
Hi!
> Does anybody have any idea when 5
any update on the 5.1 general release date? is it still on target for Q4 -
Q1? any narrower window?
On 8/30/06, Colin Charles <[EMAIL PROTECTED]> wrote:
Logan, David (SST - Adelaide) wrote:
Hi!
> Does anybody have any idea when 5.1 may come to General Release? I am
> particularly interested
Logan, David (SST - Adelaide) wrote:
Hi!
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster as I have several databases
(around 50) totalling 26Gb and would like to consider moving to this
version because of the Cluster Disk Data Stora
Logan, David (SST - Adelaide) wrote:
Hi Folks,
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster as I have several databases
(around 50) totalling 26Gb and would like to consider moving to this
version because of the Cluster Disk Dat
The cluster engine has been available since the 4.0 tree, I believe. You can
begin using it immediately with 5.0 (which is GA).
David
Logan, David (SST - Adelaide) wrote:
Hi Folks,
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster
23 matches
Mail list logo