Rolf Hopkins wrote:
>
> While you can use space in column names, it is not a very good idea as some
> systems can't handle spaces. Your just begging for trouble if you do use
> space. Better to use underscores instead.
>
> ----- Original Message -----
> From: "Mohamad Ilhami" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 10:13
> Subject: space in column name and table name, standard?.
>
> > Hi,
> >
> > I think mysql support space in column name and table name, using left
> > tick " ` " like
> >
> > create table `my foo` (`foo column` char(10) primary
> > key);
> >
> > But phpmyadmin is broken with this. So, What about the standard?
> >
> > TIA
> >
> > -ilham-
Think of it this way. If spoken languages were allowed to use spaces in
individual words, would we be able to process communications as effectively and
quickly?
Perhaps, if a space is desired in a column name in a table, an underscore would
suffice, i.e.: My_Column, instead of `My Column`. Would make the statement:
"Please insert $1MM into My_Account" more understandable and efficient to
process.
Spaces, should be avoided in `Column Names` and in File\ Names.
Regards,
Van
--
=========================================================================
Linux rocks!!! http://www.dedserius.com
=========================================================================
---------------------------------------------------------------------
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