[Zope] SQL

[Markus Hochreiter]

I have used the Gadfly Database Connection, not MySQL, I have tried also:

CREATE TABLE adressbook
 (nr INTEGER,
 vorname VARCHAR(30),
PRIMARY KEY(nr)
 )


but no success!
mex

-----Ursprüngliche Nachricht-----
Von: <jeffr@odeon.net>
An: Markus Hochreiter <mh@pernau.at>
Cc: <zope@zope.org>
Gesendet: 11 Mai 2000 23:13
Betreff: Re: [Zope] SQL


>
> check out http://www.devshed.com/
>
> They have a howto that covers basic MySQL commands, including
> setting up a basic table with a primary key.
>
> Jeff
>
> On Thu, 11 May 2000, Markus Hochreiter wrote:
>
> > Hi,
> > How I can create a table with a primary key? I have tried the following:
> >
> > CREATE TABLE adressbook
> > (nr INTEGER PRIMARY KEY,
> > vorname VARCHAR(30)
> > )
> >
> > what's wrong?
> > I get always a error message:
> >
> > Error, exceptions.SyntaxError: unexpected token sequence.near ::
'ook\012(nr
> > INTEGER'*' PRIMARY KEY,\012v' ******************************* current
state
> > = 163 expects: ',', ')', ('nomatch1',) current token = ((-8,
> > 'user_defined_name'), 'PRIMARY')
> >
> >
> > thanks for your help!
> >
> > mex
> >
> >
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )
> >
>
>