I'm new to MySQL. I have installed MySQL v5.0.27 on Windows 2000
Professional for some practice.
I created a table as follows:
create table users (user_id int unsigned not null auto_increment, user_pass
char(16), user_name tinyblob, primary key (user_id));
Then inserted some records using the following statement:
insert into users values(null, password('password'), encode('myname',
Finally I tried to retrieve one record as follows:
select user_id from users where (user_pass = password('password')) and
(decode(user_name, 'w1cket') = 'myname');
According to the book that I'm following, it should retrieve "user_id=1" but
it's not responding at all. It's not even generating any errors.