[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: A space is contained in colum??
From:       "Jay Fesco" <jay () cordaxis ! com>
Date:       2001-10-31 20:18:42
[Download RAW message or body]

> When I create a table, one colum contains a space, how can I caeate it
> correctly?
> 
> like:
> 
> CREATE TABLE mytable(
>  name CHAR(60) NOT NULL,
>  Email VARCHAR(50) NOT NULL,
>  Thrid colum CHAR(60), ///////////////////////////////Here there is a
> space?????????????
>  PRIMARY KEY (Email)
> );
> 

MySQL does not allow spaces in column names.  Try:     ThridColum CHAR(60), 

---------------------------------------------------------------------
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 <mysql-thread89654@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]