Assuming that you do have a primary key, how can you grab the last record
you inserted? Can you use @@IDENTITY, or something like that?
"Christian Reiniger" <[EMAIL PROTECTED]> wrote in message
01030310383101.00589@chrisbig">news:01030310383101.00589@chrisbig...
On Saturday 03 March 2001 05:16, you wrote:
> i'm having a little bit of problems with a little mysql table i'm
> using. the table has no primary key nor index nor nothing.
>
> i was wondering if it's possible to select the last inserted record of
> a table with this characteristics.
Add a primary key. now. Accesses without that will be painfully slow.
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
"These are the people who proudly call themselves "hackers" --
not as the term is now abused by journalists to mean a computer
criminal, but in its true and original sense of an enthusiast,
an artist, a tinkerer, a problem solver, an expert."
- ESR
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
