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
