3 messages in com.mysql.lists.mysqlRe: Space Column
FromSent OnAttachments
sol...@ceg.com.br12 Jan 2004 11:18 
Roger Baklund12 Jan 2004 12:59 
robert_rowe12 Jan 2004 13:29 
Subject:Re: Space Column
From:robert_rowe (robe@yahoo.com)
Date:01/12/2004 01:29:27 PM
List:com.mysql.lists.mysql

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.

mysql> CREATE TABLE g1 (`p1 GEOMETRY`);