select command in mysql doesnot return any row
Posted
by
jeyshree
on Stack Overflow
See other posts from Stack Overflow
or by jeyshree
Published on 2013-07-03T02:51:13Z
Indexed on
2013/07/03
5:05 UTC
Read the original article
Hit count: 199
i created a database using the command
CREATE TABLE login_table2(user_name VARCHAR(32), first_name VARCHAR(32),
last_name VARCHAR(32), password VARCHAR(64));
then i inserted a data using command
INSERT INTO login_table2(user_name ,first_name , last_name , password )
VALUES('ramya', 'ramya', 'muthu', 'India');
the data got inserted into the table. then i inserted another set of data using command
INSERT INTO login_table2(user_name ,first_name , last_name , password )
VALUES('jeyshree', 'jey', 'shree', 'India');
the data got inserted into the table too. then i gave the command
SELECT first_name FROM login_table2;
the command displayed all the first_ name in the table. however when i gave the command
SELECT password FROM login_table2 WHERE user_name = 'ramya';
it does not fetch anything though the entry exist in the table.mention where i am going wrong.awaiting your reply.
© Stack Overflow or respective owner