I created a database using the SQL command
Expand|Select|Wrap|Line Numbers
- CREATE TABLE login_table2(user_name VARCHAR(32), first_name VARCHAR(32),
- last_name VARCHAR(32), password VARCHAR(64));
Expand|Select|Wrap|Line Numbers
- INSERT INTO login_table2(user_name ,first_name , last_name , password )
- VALUES('ramya', 'ramya', 'muthu', 'India');
Then i inserted another set of data using the command mentioned below.
Expand|Select|Wrap|Line Numbers
- INSERT INTO login_table2(user_name ,first_name , last_name , password )
- VALUES('jeyshree', 'jey', 'shree', 'India');
Then i gave the command below
Expand|Select|Wrap|Line Numbers
- SELECT user_name FROM login_table2;
However when i gave the command below it does not fetch anything though the entry exist in the table.
Expand|Select|Wrap|Line Numbers
- SELECT password FROM login_table2 WHERE user_name = 'ramya';