Well, I loaded mySQL 3.23.32 onto my RedHat 6.2, kernel 2.2.14-5.0 box, and
the installation appears to have gone well. I ran through the problem
selects in the tutorial and of course it works properly. (Tutorial steps at
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Ex
Thanks for looking at my problem and giving me a hint.
> Do a myisamchk on your table. It sounds like you're having
> trouble with a corrupted index.
>
First run of myisamchk indicated "1 clients is using or hasn't closed the
table properly"
I ran myisamchk -r on the shop.MYI and got the messag
o: "John Wallace" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, January 23, 2001 8:16 PM
> Subject: Re: newbie question re: manual tutorial
>
>
> >
> > try;
> >
> > select article, dealer, price from shop w
y 23, 2001 8:16 PM
Subject: Re: newbie question re: manual tutorial
>
> try;
>
> select article, dealer, price from shop where price = '19.95';
>
> notice the "'" around the value? :)
>
> Hope that does it for you.
>
>
try;
select rticle, dealer, price from shop where price = '19.95';
notice the "'" around the value? :)
Hope that does it for you.
Atle
On Tue, 23 Jan 2001, John Wallace wrote:
> mysql> SELECT article, dealer, price
> -> FROM shop
> -> WHERE price=19.95;
> Empty set (0.00 sec)
>