Re: Suspected Bug

2002-02-15 Thread SubbaReddy M
TABLE X1 TO X2; ERROR 1064: You have an error in your SQL syntax near 'RENAME TABLE X1 TO X2' at line 1 mysql Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http

Re: Suspected Bug

2002-02-15 Thread SubbaReddy M
I am afraid it's not a bug, rather a syntax error. please follow the syntax to rename the table: mysql alter table X1 rename as X2; Regards, ~ SubbaReddy .M - Original Message - From: SubbaReddy M [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 15

MySQL - row,table level locking?

2002-02-03 Thread SubbaReddy M
(); where $sth = $dbi-open(dbi:mysql:...); 2. Is it possible to Row level lock and Table level lock in MySQL, if yes, How could we achieve this in PERL-DBI ? Please, kindly clarify. Thanks in advance. ~ SubbaReddy .M Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http

Re: How to get connected with mysql using perl scripts

2002-01-30 Thread SubbaReddy M
Hi, Check the following links: http://dbi.symbolstone.org/ http://www.saturn5.com/~jwb/dbi-examples.html http://www.oreilly.com/catalog/perldbi/ Best of luck. ~ SubbaReddy .M E-mail: [EMAIL PROTECTED] W3Page: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message

Re: Urgent Help needed

2002-01-30 Thread SubbaReddy M
in with sequence numbers for you automatically. Best of luck. ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad ( http://www.frontlinesoft.com ) Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message - From: Karuku

Re: How to get connected with mysql using perl scripts

2002-01-30 Thread SubbaReddy M
And here some more good links for DBI: http://www.he.net/adm/mysql/chapter7.html http://www.he.net/adm/mysql/chapter6.html ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad ( http://www.frontlinesoft.com ) Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy

unable to run the mysql server on Start up on Solaris?

2001-12-23 Thread SubbaReddy M
and wish you happy Christmas and happy new year 2002 for all. ~ SubbaReddy .M - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Amazing, zero length files in mysql install kit !!

2001-12-23 Thread SubbaReddy M
also 0 (zero) length file. Please, update the kit. So, now i am continuening with mysql-3.22 on solaris. it's working fine. With regards, ~ SubbaReddy .M - Before posting, please check: http://www.mysql.com/manual.php

Amazing, zero length files in mysql install kit !!

2001-12-23 Thread SubbaReddy M
(zero) length file. Please, update the kit. So, now i am continuening with mysql-3.22 on solaris. it's working fine. With regards, ~ SubbaReddy .M - Before posting, please check: http://www.mysql.com/manual.php (the manual

unable to run the mysql server on Start up on Solaris?

2001-12-23 Thread SubbaReddy M
and wish you happy Christmas and happy new year 2002 for all. ~ SubbaReddy .M - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request