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`); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]