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 )