RE: Generating UPDATE in loop, how to deal with pesky comma - SOL VED

2003-11-26 Thread Swati K
this is in which version of MYSQL.. One cant write procedures and functions in MYSQL 4.0.12... Regards Swati kalia http://www.mecklai.com where risk meets its match *** -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent: Thursday,

Functions and Procedures in Mysql

2003-11-25 Thread Swati K
Hi People, wanted to know if one can write a Function or a procedure in a mysql 4.0.12..??? Also about this data dump, i went to C:\ and typed mysqldump test. .. this thing ran for quite some time but where was the dump finally could figure that out .. can some one help me on this.. thanks in

RE: Functions and Procedures in Mysql

2003-11-25 Thread Swati K
thanks... -Original Message- From: Mikael Fridh [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 4:23 PM To: Swati K; [EMAIL PROTECTED] Subject: Re: Functions and Procedures in Mysql Regarding your mysql dump If you did not redirect standard output (mysqldump test

Database Commit transaction !!!!!

2003-11-17 Thread Swati K
hi all, I am trying to insert data into MYSQL via a excel sheet. But the minute i disconnect ..the data disappears from the data base.. some how the transaction is not getting committed.. I am using ADO Recordset and USing both insert and Update for Data manipulation.. Do advise as to why this

Database Dump

2003-11-15 Thread Swati K
Hi All I have just started working on MYSQL. Can ne one help on How to take a database Backup? and how does one transfer the MYSQL database from one Comp to another one? Regards Swati kalia http://www.mecklai.com where risk meets its match *** This message