Hello,
A solution to my problem:
"For an athlete's first entry in the database I need a column
value of 1. The second performance entry of the same athlete
would have a value of 2. And so on."
has been posted by Paul Dubois:
ALTER TABLE tbl_name
ADD seqnum INT UNSIGNED NOT NULL AUT
Hello,
Thank's for your interest Paul. I did a poor job
of explaining my problem. Here is another go:
For an athlete's first entry in the database I need a column
value of 1. The second performance entry of the same athlete
would have a value of 2. And so on.
I need to apply this retrospectively t
Hello,
I have a mySQL database with a large table of
athletic performances where every athlete has
a row for every performance. My problem is to
make a column which is a sequential count of
each athlete's performances. The table is in
chronological order. Have been trying with PHP
but I am very mu
