[Zope] SQL

Dimitris Andrakakis Dimitris Andrakakis" <dandraka@engineer.com
Sat, 13 May 2000 19:02:44 +0300


Markus wrote:
> CREATE TABLE adressbook
> (nr INTEGER PRIMARY KEY,
> vorname VARCHAR(30)
> )

Try this:
CREATE TABLE adressbook
(nr INTEGER 
vorname VARCHAR(30)
PRIMARY KEY(nr)
)

The way I do it (2nd line only):
nr int not null auto_increment,

Dimitris Andrakakis
http://atlas.central.ntua.gr:8000/~mc94068