Hello people,

I  am  new to MySQL (to all SQL, better said) and I am in need of some help.

I create a table with these characteristics:


 mysql> CREATE TABLE Usuarios (Nombre TEXT NOT NULL,
         -> Password TEXT NOT NULL,
         -> Permiso INT(1),
         -> PRIMARY KEY(Nombre(30)));

 Query OK, 0 rows affected (0.05 sec)


This allows me to insert things like:     INSERT INTO Usuarios
(Nombre,Password) VALUES ('','');

I need to force those fields to have at least one letter or number, not
empty, nor space.
Is there a way I can do this, at least having it not empty?.
Thank you very much.
Regards,
                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

Reply via email to