List:General Discussion« Previous MessageNext Message »
From:mfatene Date:May 11 2005 10:22am
Subject:Re: query to lowercase database columns names
View as plain text  
Hi,
this is the idea,

mysql> create table t (01_t varchar(10));
ERROR 1046 (3D000): No database selected
mysql>
mysql> use world
Database changed
mysql> create table t (01_t varchar(10));
Query OK, 0 rows affected (0.20 sec)

mysql>
mysql>
mysql> desc t
    -> ;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| 01_t  | varchar(10) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.01 sec)

mysql> alter table t change 01_t something_01_t varchar(15);
Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc t
    -> ;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| something_01_t | varchar(15) | YES  |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)


Scripting this query on all tables, and all columns from a perl or php script
can help you

Mathias



Selon zzapper <david@stripped>:

> On Mon, 09 May 2005 17:32:29 +0100,  wrote:
>
> >Hi,
> >Is there a query which will "alter" a table to rename all the columns to
> lowercase
> >
> >eg Price to price,  Quantity to quantity
>
> Funny how sometimes a UseNet query is answered in minutes, and or exites a
> flurry of responses, and
> othertimes like here zilch!
>
>
>
> I've got a converted from Excel spreadsheet to mysql database, which has
> mixed case column names and
> also columns beginning with a digit eg 01_name, 02_address etc what upsets
> PHP considerably.
>
> So I'd like to have a way to generically rename all columns beginning with a
> numeric
> form ^\d.* to someprefix_&
>
> Is it not possible to write such a query, or is this best done by Perl or PHP
> script?
>
> --
> zzapper
> vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?"
> http://www.rayninfo.co.uk/tips/ vim, zsh & success tips
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


Thread
query to lowercase database columns nameszzapper9 May
  • Re: query to lowercase database columns nameszzapper11 May
    • Re: query to lowercase database columns namesmfatene11 May
  • Re: query to lowercase database columns nameszzapper11 May
RE: Re: query to lowercase database columns namesJay Blanchard11 May
  • RE: Re: query to lowercase database columns namesmfatene11 May
  • Re: query to lowercase database columns nameszzapper12 May