Jeremy Cole wrote:
Hi,
Both tables should hold the same number of records.
However, I've discovered that 'Close' is one less than 'Open' (1693 vs
1694).
How can I find out which record is missing from 'Close'? I know it's
not the case of an extra entry in 'Open' because 1694 divides evenly
by
I have 2 tables 'Open' and 'Close' with this structure:
mysql describe Open;
+---+-+--+-+--+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+--+---+
| ID| int(10) unsigned
Hi,
Both tables should hold the same number of records.
However, I've discovered that 'Close' is one less than 'Open' (1693 vs
1694).
How can I find out which record is missing from 'Close'? I know it's not
the case of an extra entry in 'Open' because 1694 divides evenly by 7,
whereas 1693