Micheal,
Your query trouble shooting tip showed me my error - see below:
Sorry here is the SHOW CREATE TABLE:
mysql> show create table `maintenance`;
+-+-
Hagan,
Close but not quite what I asked for. The schema for your table is
what you get from SHOW CREATE TABLE `mytable`. It will show all the
indexes and, most imporatantly, make it trivial for someone trying to
assist you in your investigation to re-create your problem.
It is good to see the q
mysql> desc maintenance;
++--+--+-++---+
| Field | Type | Null | Key | Default| Extra |
++--+--+-++---+
| indate | date | YES | | NULL