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]>; &l
mysql> RENAME 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, Frontlines
th->execute(); 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. Programme
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
ou add an AUTO_INCREMENT column, column values are filled 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/msubbare
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
anks in advance
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
(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 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
anks in advance
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
anks in advance
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
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
12 matches
Mail list logo
