Garry,
CREATE TABLE breeding (
rec SMALLINT(4) UNSIGNED AUTO_INCREMENT,
sire SMALLINT(4) UNSIGNED,
dam SMALLINT(4) UNSIGNED,
paired DATE,
split DATE,
num_offspring TINYINT(1) ZEROFILL,
PRIMARY KEY (rec)
);
First, we define if a pair was breeding for
Wow Garry,
I know that I like to kick-start my brain by getting 'into' a list problem/challenge
in the (London) mornings,
but today I'm completely beaten. Thanks for the broad explanation, which is probably
quite meaningful, but I'm
not into breeding (could that statement be misunderstood?)
On Wed, 30 Jan 2002, DL Neil wrote:
Can I request some db-speak please? You already have a tbl (or more).
So let's start by asking for the table definitions
The table definition is as follows:
CREATE TABLE breeding (
rec SMALLINT(4) UNSIGNED AUTO_INCREMENT,
sire SMALLINT(4) UNSIGNED,
Garry,
Could you please explain (define) in one sentence(paragraph) what end
result you want. It might be possible to handle it in one SQL statement.
Miles Thompson
At 09:54 AM 1/30/2002 +1100, Garry Optland wrote:
On Wed, 30 Jan 2002, DL Neil wrote:
Can I request some db-speak please?
On Thu, 31 Jan 2002, DL Neil wrote:
Garry,
I regret to say that I can't see an immediate answer.
CREATE TABLE breeding (
rec SMALLINT(4) UNSIGNED AUTO_INCREMENT,
sire SMALLINT(4) UNSIGNED,
dam SMALLINT(4) UNSIGNED,
paired DATE,
split DATE,
num_offspring TINYINT(1)