11 Nov
2004
11 Nov
'04
11:49 a.m.
Chris writes:
The front ends for mysql must have something similar so that when you are, for example, scrolling down a list of records there is something which tells you which record you're at.
Yes: the primary key, if there is one. If you try stuff like this with phpMyAdmin it does its best to work out a unique field (or I think it can cope with a set of unique fields), but if it can't uniquely identify the record then I'm pretty sure stuff like record edit/delete icons will vanish from the view.
There is no concept of "the Nth record" in mySQL, or at least if there is it's a recent addition - I've not really played with 4.x past its inherited 3.x capabilities.
--
Mark Rogers,
More Solutions Ltd :: Tel: 0845 45 89 555