Courrier recu par moi-meme. ; 29 Oct 2002 03:57:13 -0000
Message recu de: unknown (helo CAGMAW200710) par 207.35.122.83 avec SMTP; 29 Oct 2002
03:57:13 -0000
Message-ID: <002301c27f52$dc1cb570$[EMAIL PROTECTED]>
From: "blah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: "FullTest" as the column name
Date: Tue, 29 Oct 2002 08:55:37 -0500
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Hi,
I want to use MySQL to store ESM (Symantec Enterprise Security Manager)
data. The problem is that in one of their table, there is a field named
"FullText".
I have tried to create it in the CREATE TABLE statement and it gives me this
message :
mysql> create table ESMMessage2 (FullText text NOT NULL);
ERROR 1064: You have an error in your SQL syntax near 'NOT NULL)' at line 1
I have also tried to create the table, and then add the column with an ALTER
TABLE:
mysql> alter table ESMMessage add (FullText text NOT NULL);
ERROR 1064: You have an error in your SQL syntax near 'NOT NULL)' at line 1
Would it be possible to have a column with this name ? How ?
Yan
---------------------------------------------------------------------
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
