RE: insert + AUTO_INCREMENT

2001-03-05 Thread Johnny Withers
PROTECTED]] Sent: Sunday, March 04, 2001 5:56 AM To: [EMAIL PROTECTED] Subject: insert + AUTO_INCREMENT hi, i have a problem i have a database table created with the statement: CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message text, username varchar

Re: insert + AUTO_INCREMENT

2001-03-05 Thread Robert Vetter
Joris Kluivers wrote: > > hi, > > i have a problem > i have a database table created with the statement: > CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, >message text, username varchar(100), UNIQUE id (id); > > I insert records with: > INSERT INTO chatmessages

RE: insert + AUTO_INCREMENT

2001-03-05 Thread Cal Evans
check the archive, someone answered that one this weekend. Cal http://www.calevans.com -Original Message- From: Joris Kluivers [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 04, 2001 5:56 AM To: [EMAIL PROTECTED] Subject: insert + AUTO_INCREMENT hi, i have a problem i have a

insert + AUTO_INCREMENT

2001-03-05 Thread Joris Kluivers
hi, i have a problem i have a database table created with the statement: CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id); I insert records with: INSERT INTO chatmessages (message, username) VALUES ('this is my mes