How to unsubscribe to this mailing list?

2002-06-18 Thread Zhu George-CZZ010
Can anyone let me know how to unsubscribe to this mailing list? Thank you very much in advance. sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

MySql to Oracle migration

2001-06-12 Thread Zhu George-CZZ010
Is there a way/tool to migrate the Application from MySql to Oracle 8i? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

what's the command to list all the tables in the DB

2001-05-29 Thread Zhu George-CZZ010
Previously, I used "SELECT table_name FROM tabs" to get all the table names, but now, I logged into a new box using SQLPlus, but there is no record in the tabs table. So, how can I get the table names in that database (Oracle)? Thanks! -

How many records can MySql handle?

2001-05-25 Thread Zhu George-CZZ010
If each record is about 1K byte, how many records can MySql handle? Does anyone have any estimation or hands-on experience? Thank you very much in advance. Regards, George - Before posting, please check: http://www.mysql.c

to upper case function

2001-03-27 Thread Zhu George-CZZ010
There's a function in SQL to convert strings to upper case (sounds like to_upper()? ), I don't have the reference book at hand, does anyone know the syntax or that function? Thank you very much in advance. - Before posting, pl

MySql backup and restore.

2001-03-20 Thread Zhu George-CZZ010
Hi, If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the whole database, what's the script/command to restore it? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the m