I have this SQL statement:
CREATE TABLE rooms (
room_name TEXT UNIQUE,
last_updated TIMESTAMP DEFAULT
CURRENT_TIMESTAMP NOT NULL,
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.