On Sun, Feb 18, 2001 at 12:30:57PM +0200, Yoav Bornstein wrote:
> Is there a way to create column names with spaces ?
> 

Yes you can use backquotes for this:

create table `a b` ( `x y` int );

I'm not sure this is documented though, so you may want to check
before using this.

show create table uses this syntax so I guess it is supported
;-)


Regards,

Fred.

-- 
Fred van Engen                              XO Communications B.V.
email: [EMAIL PROTECTED]             Televisieweg 2
tel: +31 36 5462400                         1322 AC  Almere
fax: +31 36 5462424                         The Netherlands

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to