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 results.
For instance,
SELECT * FROM pet WHERE 'birth' >= "1998-1-1";
+----------+--------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+----------+--------+---------+------+------------+------------+
| Fluffy | Harold | cat | f | 1993-02-04 | NULL |
| Claws | Gwen | cat | m | 1994-03-07 | NULL |
| Buffy | Harold | dog | f | 1989-05-13 | NULL |
| Fang | Benny | dog | m | 1990-08-27 | NULL |
| Bowser | Diane | dog | m | 1989-08-31 | 1995-07-29 |
| Chirpy | Gwen | bird | f | 1098-08-11 | NULL |
| Whistler | Gwen | bird | | 1997-12-09 | NULL |
| Slim | Benny | snake | m | 1996-04-29 | NULL |
+----------+--------+---------+------+------------+------------+
or
select * from pet where birth > "1997-1-1";
+----------+-------+---------+------+------------+-------+
| name | owner | species | sex | birth | death |
+----------+-------+---------+------+------------+-------+
| Whistler | Gwen | bird | | 1997-12-09 | NULL |
+----------+-------+---------+------+------------+-------+
1 row in set (0.00 sec)
Is there something wrong with my table? I had to give myself FILE
privileges before I could load my table data from a file. (The tutorial
didn't mention that.)
Is there something wrong with my installation?
