Re: Space Column

2004-01-12 Thread Roger Baklund
* [EMAIL PROTECTED] > I am beginning in mysql, and I do not obtain to create a table > with a space column. > some friend could help me? > > mysql> CREATE TABLE g1 (p1 GEOMETRY); > Error 1064 : The error message got lost in the mail. Beware that spatial support is introduced in mysql version 4.1,

Re: Space Column

2004-01-12 Thread robert_rowe
Just enclose the column name in backticks (upper left key on your keyboard just below ESC). Be warned that if you do this you will ALWAYS have to refer to this column using the backticks. It would be MUCH better to remove the space from the name. You might consider using an underscore instead.