Re: IF

neither. Assuming the worst is safer, and then one uses CASE ..., but if not, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=prathiman...@vsnl.net Prathima Rao blackberry mail

version 5 to 4

Regards, Prathima Rao

Re: version 5 to 4

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 i tried

Re: Slow connection over VPN

it depends on the vpn router if u need more info let me know - Original Message - From: Duncan, Kurt (MCUSA) k...@medconnectusa.com To: mysql@lists.mysql.com Sent: Tuesday, February 17, 2009 12:09 AM Subject: Slow connection over VPN We have an application using mysql. When we run

Re: Happy New Year

HAPPY NEW YEAR - Original Message - From: John Daisley john.dais...@mypostoffice.co.uk To: MySQL General List mysql@lists.mysql.com 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,

mysql not starting

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

error in copy data from mysql 4.1 to mysql 5.0 server

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

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

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 PROTECTED] Cc: mysql@lists.mysql.com

mysql server

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

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

hello, how can i create a binary log in a new database - Original Message - From: Adam Lipscombe [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: 14/12/2005 3:50 PM Subject: Mysqldump INSERT statements (Was Mysqldump line endings) (--result-file) option to save your output but use

restoring datewise data

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

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:

mysql export resultset to xml format

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 --

mysqldump for xml

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]

Re: Country codes

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]; mysql@lists.mysql.com Sent: 21/11/2005 6:18 AM Subject: Re: Country codes I'm not saying it was an inappropriate way to

vpn connectivity

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

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: mysql@lists.mysql.com Sent: 04/10/2005

restore.sql database

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

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

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:

table handle error

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

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

error in installing

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:

Re: error in installing

with administrative privileges, on the command-line: C:\sc delete mysql [SC] DeleteService SUCCESSregardsprathima rao - Original Message - From: prathima rao [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, April 01, 2005 6:09 AM Subject: error in installing hello, i have windows 2000 i

ERROR WHILE LOADING

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 message.

sqlyog

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

restoring database

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

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