Hi Jeremy,
I just noticed your name today on the mysql mailing list and recognised your
name. I'm
a new user of MySQL and saw that you will soon have a new book out. I've
scanned other books on MySQL but found that they were either somewhat dated
or of limited value. So,
I look forward to seeing your new book when it comes into print!
Dan Jordan
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 3:02 PM
To: Steve Bearss
Cc: MySQL Info
Subject: Re: auto_increment, creating table
On Tue, Jan 08, 2002 at 04:56:52PM -0500, Steve Bearss wrote:
what is wrong with this statement?
mysql create table message (messageId AUTO_INCREMENT, timePosted
VARCHAR(25),
- userEmail VARCHAR(30), messagePosted MEDIUMBLOB);
ERROR 1064: You have an error in your SQL syntax near 'AUTO_INCREMENT,
timePoste
d VARCHAR(25),
userEmail VARCHAR(30), messagePosted MED' at line 1
You haven't specified a data type for the field, such as INTEGER.
Try:
messageId INTEGER AUTO_INCREMENT, ...
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 5 days, processed 126,780,679 queries (246/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php