lower and upper cases

[lesina]

Hi guys,

i need some help.

My table fields in my database are in upper cases but i need to change them all leaving them in a special format (each word must start with caps and the rest of the word must be in lower cases).
Example:
Lisbon=Lisbon

Is there a way of doing this in sql??

In another way, this can be done in excel using the proper function.But to achieve that, i would have to import every table into excel format, use the proper function and put the new tables back in the database.

If there is no way of doing this in sql, the excel way is possible??

Thanks a lot in advance
===================
* Marta Oliveira *
===================
marta100@aeiou.pt
-------------------
CPC_TA- Braga
-------------------
Portugal
===================

 

[tviman]

I'm a real rookie when it coms to Mysql but I think what you want to do is possible by using the CREATE TABLE sql command. Unfortunately, you'll have to do this for each table and you'll have a lot of hand work to do. Might just be easier to create new temporary tables, name the fields to your liking, and copy the data over.

??? There's always a better way...

 

[KarveR]

Get a GUI frontend or phpmyadmin and rename them to your liking.

mysqlfront or similar should be able to help you easily. ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[piti]

or create your own php/perl/shell script renamer tool
should be rather easy using "show tables" and "explain table_name"