List:General Discussion« Previous MessageNext Message »
From:prathima rao Date:June 19 2006 1:50pm
Subject:Re: error in copy data from mysql 4.1 to mysql 5.0 server
View as plain text  
hi,,

the query is select sum(gtotal) from invoice this if i connect to 4.1 says
14000 but in 5.1 it says 0.00

why so

is it because i copy data from 4.1 to 5.1

rao
----- Original Message ----- 
From: "Peter Brawley" <peter.brawley@stripped>
To: "prathima rao" <prathimanrao@stripped>
Cc: <mysql@stripped>
Sent: Monday, June 19, 2006 6:57 PM
Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server


> prathima rao wrote:
> > hello every one,
> >
> > i have two mysql servers one is the local server 4.1 and one is the
> > centralised server 5.0 . i copy data from 4.1 to 5.0 through a option
called
> >
> > copy database to another server/host - (drop table if exists)
> >
> > during this process i am not getting the same resule as i get in 4.1 ie
im
> > using a text box which sums up a value in a table that in 4.1 is showing
> > correct but in 5.1 is showing 0 when displayed in front end(visual basic
5)
> > even though it has the sum correct data
> >
> > can anyone help me
> >
> Post the query.
>
> PB
> > regards
> >
> > rao
> >
> >
> >
>
>
> -- 
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.9.0/368 - Release Date: 6/16/2006
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.9.0/368 - Release Date: 6/16/2006
>
>

Thread
Need Information About MySql Support for Application BlocksVeerabhadra rao Narra17 Jun
  • error in copy data from mysql 4.1 to mysql 5.0 serverprathima rao19 Jun
    • Re: error in copy data from mysql 4.1 to mysql 5.0 serverPeter Brawley19 Jun
  • Re: error in copy data from mysql 4.1 to mysql 5.0 serverprathima rao19 Jun
    • Re: error in copy data from mysql 4.1 to mysql 5.0 serverDan Buettner19 Jun
    • Re: error in copy data from mysql 4.1 to mysql 5.0 serverPeter Brawley19 Jun