On Wed, 11 May 2005 15:08:50 +0200, wrote:
>Selon Jay Blanchard <[EMAIL PROTECTED]>:
>
>> [snip]
>> I've got a converted from Excel spreadsheet to mysql database, which has
>> mixed case column names and
With advice from this thread, what I ended up doing was
>show create table tbl_products;
T
Selon Jay Blanchard <[EMAIL PROTECTED]>:
> [snip]
> 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 r
[snip]
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.*
On Wed, 11 May 2005 12:22:21 +0200, wrote:
>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>
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
-> ;
+---+-+--+-
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 h
Hi,
Is there a query which will "alter" a table to rename all the columns to
lowercase
eg Price to price, Quantity to quantity
--
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
