Issue with null and empty Strings .

[nse-dba dba]

Hi,
We are new to MySQl. We have an mysql application which is in testing phase. We have an application table where userid's and passwords are stored.
Please find details of the create script of the table. We are using innodb engine for all the application tables. The version of mysql is 5.0.68-enterprise-gpl.

CREATE TABLE `login_details` (
`USERID` varchar(50) NOT NULL,
`PASSWORD` varchar(50) NOT NULL,
`FIRSTNAME` varchar(50) default NULL,
`LASTNAME` varchar(50) default NULL,
`EMAIL` varchar(50) NOT NULL,
`MISC` varchar(50) default NULL,
PRIMARY KEY (`USERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Now I am inserting blank strings into the table
insert into login_details values ('','','','','','');

The issue here is :

I am able to login to my application without giving userid and password in the login screen.

Please tell us how this issue can be solved in db level.

We are aware that "NULL" , ' '<blank string> are different in mysql.

Please suggest us a solution ?

Thanks,
Nse-dba team



Edited 2 time(s). Last edit at 01/16/2009 05:28AM by nse-dba dba.