MySQL Forums
Forum List  »  Oracle

Issue with null and empty Strings .
Posted by: nse-dba dba
Date: January 13, 2009 12:39AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Issue with null and empty Strings .
6214
January 13, 2009 12:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.