Creating a column called 0

bubblenut

Hi, I am trying to create a column called 0 (zero) I know it can be done as I have done it before (but forgoten, obviouly) If anyone knows I would really appreciate some help.
Bubble

TTT

back to basics ...

column1 , right
1column , wrong
1 , wrong

ultraslacker

Why indeed?

chriskl

You need to backquote it if it's MySQL:

CREATE TABLE blah (0 integer);

Chris

bubblenut

Cheers crisk.
The reason I needed fields named like that is for my fuzzy search I have a dictionary table with word_id, word, and then ints [a-z0-9] which count how many of each alpha num is contained within the word. This allows for some very quick very versatile fuzzy searching, and it's just easier to have each column named after what it's representing.
Bubble