Re: "IF"

2011-03-15 Thread Prathima Rao
t;< > Yes, but Access s "IIF", of the same use, evaluates all three, and the > documentation explicitly says so. MySQL s, that I have seen, says neither. > Assuming the worst is safer, and then one uses CASE ..., but if not, > > -- MySQL General Mailing List Fo

Re: version 5 to 4

2010-02-14 Thread Prathima Rao
lp Thanks & Regards, Prathima Rao - Original Message - From: Prathima Rao To: mysql@lists.mysql.com Sent: Monday, February 15, 2010 12:32 PM Subject: version 5 to 4 hi mysql tem, i have a version 5 on which i have developed a database now one of the systmem has 4

version 5 to 4

2010-02-14 Thread Prathima Rao
lp Thanks & Regards, Prathima Rao

Re: Slow connection over VPN

2009-02-16 Thread Prathima Rao
it depends on the vpn router if u need more info let me know - Original Message - From: "Duncan, Kurt (MCUSA)" To: Sent: Tuesday, February 17, 2009 12:09 AM Subject: Slow connection over VPN We have an application using mysql. When we run it locally there are no issues. If we try

Re: Happy New Year

2008-12-31 Thread Prathima Rao
HAPPY NEW YEAR - Original Message - From: "John Daisley" To: "MySQL General List" Sent: Thursday, January 01, 2009 7:25 AM Subject: Happy New Year Just thought I would take this opportunity to wish everyone on the list a happy, prosperous and peaceful 2009. John Daisley Email: j

mysql not starting

2007-10-24 Thread Prathima Rao
this has been a problem to me from mysql 3.1 version now in 4.1 also the same problem during the instant configuration wizard the last screen which has start service does not turn green and mysql doesnt start ive tried removing mysql and reinstalling does this problem has anything to do with po

Re: error in copy data from mysql 4.1 to mysql 5.0 server

2006-06-19 Thread prathima rao
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" <[EMAIL PROTECTED]> To: "prathima rao" <[EMAIL

error in copy data from mysql 4.1 to mysql 5.0 server

2006-06-19 Thread prathima rao
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

mysql server

2006-03-28 Thread prathima rao
i have a hp server . i have installed mysql 4 in that when ever i shut down the system and start again the mysql server does not start it says its an error when i try to reconfigure it service started will be disabled can anyone help me out - Original Message - From: "leo huang" <[EMAIL

working on Microsoft® Windows Server™ 2003

2006-01-14 Thread prathima rao
hi, can new mysql work on Microsoft® Windows Server™ 2003 regards prao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to create binary logging for a database

2005-12-14 Thread prathima rao
hello, how can i create a binary log in a new database - Original Message - From: "Adam Lipscombe" <[EMAIL PROTECTED]> To: Sent: 14/12/2005 3:50 PM Subject: Mysqldump INSERT statements (Was Mysqldump line endings) >> (--result-file) option to save your output but use the > output redi

restoring datewise data

2005-12-06 Thread prathima rao
hello, i have a database in mysql i want to restore the backup server every 15 minutes if i take a backup in sql its huge and my transfer cost of the data will be very high can anyone suggest how to restore the data in small size regards prao -- MySQL General Mailing List For list archives:

recording time of data entry

2005-12-03 Thread prathima rao
hi all, can anyone tell me if we can anywhere find out what time that data was entred in the database i was actually checking if we can find out what time that record got created into the database can anyone help!! regards prao -- MySQL General Mailing List For list archives: http://l

mysqldump for xml

2005-11-28 Thread prathima rao
i was tring mysqldump command line for exporting data to xml format it is giving an error can anyone help me with the command line syntax rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql export resultset to xml format

2005-11-28 Thread prathima rao
hi all, has anyone tried to export a data from a table to *.xml format i want a front end programme to do this automatically for example i have a database test in which table testing exists i want the data from that table to be exported in xml format at a click of a button regards rao --

Re: Country codes

2005-11-22 Thread prathima rao
do any one have ready made combo box with all the country codes present - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Björn Persson" <[EMAIL PROTECTED]>; Sent: 21/11/2005 6:18 AM Subject: Re: Country codes > I'm not saying it was an inappropriate way to present the data bu

vpn connectivity

2005-11-07 Thread prathima rao
hai all , im using mysql 4 version we are trying to connect inter units thriugh VPN will my database work and how? p rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql no series

2005-10-04 Thread prathima rao
i have a table slno and percentage slno contains 1 to 15 when i say order by slno it always comes 1,10,11,12,13,14,15,2 i want it in the form 1,2,3,4,5,6,7,8,9,10,11 can u help rao - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: 04/10/2005 2:19 PM Subject: Re:

restore.sql database

2005-07-19 Thread prathima rao
hello i am taking backup in *.sql format automatically how can i restore the same in the server automatically from visual basic regards p rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

log file

2005-07-18 Thread prathima rao
hi, how to create a log file of the updates done on the data in visual basic or in mysql for a particular record for example i have a purchase order record in which my junior changes say rate without my knowledge how will i know what has been changed p rao -- MySQL General Mailing List For

inserting the whole record

2005-07-16 Thread prathima rao
hi, i want to copy a whole record from one table to another like below insert into p1 values(select * from p2 where pono=1); its giving me error please help regards p rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

table handle error

2005-04-19 Thread prathima rao
hai, when ever the power goes or the system restarts when im entring data from my vb application to mysql 4 database it gets corrupted and i loose some data at the end please can any one help me in this regards prathima rao -- MySQL General Mailing List For list archives: http

graphs

2005-04-13 Thread prathima rao
hello, can anyone suggest if there is any software available to create graphs using mysql as database regards prathima rao

Re: error in installing

2005-04-01 Thread prathima rao
administrative privileges, on the command-line: C:\>sc delete mysql [SC] DeleteService SUCCESSregardsprathima rao - Original Message - From: "prathima rao" <[EMAIL PROTECTED]> To: Sent: Friday, April 01, 2005 6:09 AM Subject: error in installing > hello, > > i have

error in installing

2005-04-01 Thread prathima rao
hello, i have windows 2000 i was not able to finish the server configuration i read in one of the site that sc.exe should be present i searched but could not get the same can anyone help me regards p rao -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296

ERROR WHILE LOADING

2005-03-30 Thread prathima rao
 hai,  i was trying to install mysql 4 server on windows 2000 when configuringthe  server i received the below error in  mysql server instance configuration  "could not start the service mysql error:0"  can i know how to solve the error  regards  p rao No virus found in this outgoing messag

sqlyog

2005-01-20 Thread PRATHIMA RAO
hai, am using sqlyog for mysql i have taken back up in batch ie .sql i want to restore automatically can it be possible to restore by writing a code in vb using sqlyog i have written a programme in vb for taking back up automatically need help to restore the same automatically regards prat

restoring database

2005-01-17 Thread Prathima Rao
hai, i have written a bat file in which the data databackup has been taken in sql it runs automatically every 1 hour and sends a automatically through email now at the other end i have to manually restore the database can any one give me the codes to restore the database automatically

Re: odbc 3.51.06

2003-12-05 Thread Prathima Rao
dear mysql team, i was trying to save a file in mysql now can u please help me with an alternative that i save the file name in the database and how to retrieve back prathima rao - Original Message - From: Prathima Rao To: [EMAIL PROTECTED] Sent: 06/12/2003 9:23 AM

odbc 3.51.06

2003-12-05 Thread Prathima Rao
dear mysq team, i have myodbc 3.51.01 version now how do i upgrade to latest version 3.51.06 please help regards prathima rao