[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] [MV4] mySQL
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Wed, 19 Apr 2000, Joel Vandal wrote:
> In my error.log, I have:
>
> - - - [19/April/2000:11:52:39 -0400] cyberentrepot - bad table creation
> statement:
> > create table products (
> > code char(20) primary key,
> > product char(128),
> > manufacturer char(128),
> > sku char(128),
> > cpu char(128),
> > media char(128),
> > qte char(128),
> > price char(128),
> > poid char(128),
> > status char(128),
> > cat char(128),
> > cat1 char(128),
> > cat2 char(128),
> > cat3 char(128),
> > desc char(128),
> > base char(128),
> > prixsug char(128)
> > )
> >
> >
> > Error: You have an error in your SQL syntax near 'desc char(128),
> > base char(128),
> > prixsug char(128)
> > )
> > ' at line 16
desc is a reserved word in mysql. see
http://mysql.he.net/Manual_chapter/manual_Reference.html#Reserved_words
for the complete list.
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
