Error Creating MySQL Table

edh

Hello,

I am using phpMyAdmin to create a table. Here is my error:

=======================
Error

SQL-query :

CREATE TABLE users (id TINYINT(1) NOT NULL AUTO_INCREMENT PRIMARY KEY, username TINYTEXT(30) NOT NULL)

MySQL said:

You have an error in your SQL syntax near '(30) NOT NULL)' at line 1

Anybody have a clue?

tomhath

You have an error in the syntax. Specifically, the parser doesn't know what the (30) means.

Hint: the blob datatypes, of which tinytext is one, are predetermined length. You cannot say you want a tinytext that's only 30 bytes, tinytext is always 255 bytes. Maybe use varchar instead?

edh

That worked.

Thank you.