On Sun, Feb 18, 2001 at 03:06:08PM +0100, Jarmo Paavilainen wrote:
> Hi,
>
> ...
> > > Is there a way to create column names with spaces ?
> > >
> >
> > Yes you can use backquotes for this:
> >
> > create table `a b` ( `x y` int );
>
> Doesnt the normal (SQL9?) double quote do the trick? :
>
> create table "a b" ( "x y" int );
>
Maybe, but I don't see how you would use the column in queries
because it looks like a string constant:
select "x y" from "a b";
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