[Zope] SQL

[jeffr@odeon.net]

	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 )
>