Re: Stuck with Tutorial

2003-07-04 Thread Richard Grubb
I couldn't get the LOCAL option to work; even when I started mysql with the --local-infile argument. After reading around in the manual I decided to grant myself the FILE privilege since I am the only user on my computer where I am teaching myself mysql. On Friday, July 4, 2003, at 12:08 PM, Pa

Re: Stuck with Tutorial

2003-07-04 Thread Paul DuBois
At 11:27 -0500 7/4/03, Richard Grubb wrote: I have mysql 3.23.49 on Mac OS-X 10.1.5 and am going through the tutorial in the "MySQL Reference Manual" in Chapter 3. I get an empty set with the following command: SELECT * FROM pet WHERE birth >= "1998-1-1"; I have tried many variations which all

Re: Stuck with Tutorial

2003-07-04 Thread Ed Leafe
On Friday, July 4, 2003, at 12:27 PM, Richard Grubb wrote: SELECT * FROM pet WHERE birth >= "1998-1-1"; Try: SELECT * FROM pet WHERE birth >= "1998-01-01"; You need 2 characters for the day and month fields. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe

Stuck with Tutorial

2003-07-04 Thread Richard Grubb
I have mysql 3.23.49 on Mac OS-X 10.1.5 and am going through the tutorial in the "MySQL Reference Manual" in Chapter 3. I get an empty set with the following command: SELECT * FROM pet WHERE birth >= "1998-1-1"; I have tried many variations which all give either the empty set or incorrect resu