At 22:49 -0500 11/21/05, Ferindo Middleton Jr wrote:
I have this SQL statement:
CREATE TABLE rooms (
id SERIAL,
room_name TEXT UNIQUE,
location TEXT,
last_updated TIMESTAMP DEFAULT
CURRENT_TIMESTAMP NOT NULL,
last_user_updated TEXT,
PRIMARY KEY(id)
);
When I run this I get the following error:
ERROR 1170 (42000): BLOB/TEXT column 'room_name' used in key
specification without a key length
I'm more used to PostgreSQL and when I run this command there, I
don't get this error message. I recognized that by changing
room_name to a varchar type, I won't get the error message.
Also, the PostgreSQL mailing lists had a special group from
SQL-related issue, but I didn't see one of these types of lists in
the lists of groups for MySQL community so I'm sorry if I irritate
anyone by posting to the wrong group. Thanks.
What is your question?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
