how to work with a column name which has a space?

Question

I have a column name "user id" now when I use it in insert or... all of the following tries gave me syntax error:

insert into mytbl('user id',..
insert into mytbl(['user id'],..
insert into mytbl([user id],..

How can I solve this problem?

Please let me knbow if you need more clarification

Thanks

change it to something without a space. it may preserve your sanity — Strawberry, Jan 17 '14 at 21:34

score 5 · Accepted Answer · edited Jan 17 '14 at 21:37

5

Wrap it in ticks:

INSERT INTO mytbl(`user id`,..

to reffer to a table use

    tbl1.`user name`

edited Jan 17 '14 at 21:37

echo_Me

answered Jan 17 '14 at 21:33

John Conde

Thanks man! You solved it! I will mark it as solved :) – user385729 Jan 17 '14 at 21:33
and if I want to refer to it with a table name, would it be tbl1.[`user name`] or tbl1.`user name`.? – user385729 Jan 17 '14 at 21:35
This solution solves your immediate problem, but down the road you will be sad at having to deal with all the spaces, and how many inadvertent errors you make. – Andy Lester Jan 17 '14 at 21:37

1 Answers1