perl pra schrieb:
Hi ALL,,
I am new to perl,
I have a database which works fine in windows, Now i need to change table
names to uppercase in Linux.
So I have done the following:
I copied all the from files into /var/lib/mysql/new_db from windows to
linux.
Then changed the names to caps;
and changed the permissions to 660 (with user as mysql)
restarted the mysql server.
I can see all the tables but when i fire following query
select * from table_name
i get the following error
*./new_db/table_name.frm not found*
**
**
can anybody help me in changing the table names to upper case
when table names are in uppercase you have also write this in your queries:
select * from TABLE_NAME
or read:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
