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 )