Re: trailing space in column name

[Ingo Strüwing]

Hi Zhixuan,

Zhixuan Zhu, 09.06.2009 00:08:

> This may sound minor, but it creates lots of trouble to us. For some
> reason MySQL disallow column names with trailing space in create table.
> We're doing lots of "create table as select" type of queries and so
> statements like this will fail:
> 
> Create table test as select "command ", command_type from command_table;

just curious: Why do you want to have trailing space in column names?

Regards
Ingo
-- 
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder,   Wolfgang Engels,   Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring   HRB München 161028