-
Problem in mysql
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
-
Re: Problem in mysql
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.
-
Re: Problem in mysql
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
-
Re: Problem in mysql
Backticks, not parentheses:
Code:
CREATE TABLE `test table` (
name text(255)
)
But I do strongly advise you not to do it.
-
Re: Problem in mysql
thank u very much for ur help. now its working. thanku very much.
thank u
with thanks and regards
mmary