Problem in mysql

[mmary]

hi to all,
i want to create the table in my sql with the space. that means i want to create the table with the name test table. how can i create the tablename with space and also how can i create the column with the space.
if any body know, plz help me.


thank u

with thanks and regards
mmary

[penagate]

I think you can do it by enclosing the name in backticks (`), but I suggest you don't. It only causes headaches. Just use an underscore to separate words in indentifiers.

[mmary]

hi, thank u very much for ur help.
i was tried using enclosing, but its not working. when iam using the enclosing for select statement.its working. creating and inserting its not working . how can i solve the problem. the query i tried is


create table (test table)(name text);


plz help me.

thank u.

with thanks and regards
mmary

[penagate]

Backticks, not parentheses:

CREATE TABLE `test table` (
  name text(255)
)

But I do strongly advise you not to do it.

[mmary]

thank u very much for ur help. now its working. thanku very much.



thank u

with thanks and regards
mmary