On Thursday 08 March 2001 06:42, you wrote:
> 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?
For that I'd add another field - type "timestamp".
In MySQL, timestamp fields are automatically set to NOW() on each insert
and update *if* they are not set to something else in it (the insert or
update)
Or simply add some timestamp or datetime field that you "manually" set to
NOW() on each insert (if you don't want the date to be changed on an
UPDATE).
> 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/)
Very funny, Scotty! Now beam up my clothes...
--
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]
