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
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 )
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 )
Hi, I think primary key is not supported by Gadfly. In /Products/ZGadflyDA/gadfly/gadfly.html the syntax of the Create table statement is specified as: create table name (colname datatype[, colname datatype...]). Arpad Kiss On 11-May-2000 Markus Hochreiter wrote:
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 )
_______________________________________________ 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 )
---------------------------------- E-Mail: sekter@matavnet.hu Date: 12-May-2000 Time: 00:29:22 This message was sent by XFMail ----------------------------------
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
participants (4)
-
Dimitris Andrakakis -
jeffr＠odeon.net -
Markus Hochreiter -
sekter＠matavnet.hu