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 <[EMAIL PROTECTED]>:
> 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/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
