My name is Gastón Sancassano and I would like to make some questions about
MySQL because I am a novice.
My question is:
- How does PRYMARY KEY and UNIQUE works?
My problem is that I want to create a table with 3 columns (Nombre, Password
and Permiso) and I don't like to have the name repeated (without case
sensitive). I execute this in mysql:
mysql> CREATE TABLE Usuarios (
-> Nombre TEXT NOT NULL,
-> Password TEXT NOT NULL,
-> Permiso INT(1),
-> PRIMARY KEY(Nombre));
and the error message is:
ERROR 1170: BLOB column 'Nombre' used in key specification without a key
length
How can I create this table?.
Thanks very much,
Gastón
---------------------------------------------------------------------
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
