you are right, it is a very weird situation
urge you strongly to lobby to get the name changed
the only thing i was able to do was copy the contents into an identical table with a different name
first of all, i was not able to actually create a table this way
i had to fool it like this:
PHP Code:
create table badcolnames
( id tinyint not null primary key auto_increment
, `Case 2` integer not null
);
insert into badcolnames (`Case 2`)
values ( 937 )
, ( 21 ) , ( 101010101 );
create table badcolnames2
select id, `Case 2` as "Case #"
from badcolnames
select * from badcolnames2
id,Case #
1,937
2,21
3,101010101
against this table,
nothing works
except a plain SELECT *
so create and copy:
PHP Code:
create table badcolnames3
( id3 integer, Case3 integer )
insert into badcolnames3
select *
from badcolnames2
select * from badcolnames3
id3,Case3
1,937
2,21
3,101010101
totally weird
dBforums
>
# in query
03-25-04, 15:10
Linear Mode
