The document says it works for 4.1.x or above.
Create a table with timestamp column with default as
current_timestamp so you can avoid the INSERT load.
CREATE TABLE tmp (

ts2 TIMESTAMP DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP);



-Shanker

--- Terrence Brannon <terry@...> wrote:

> During development, I often want to quickly see if a
> table just
> successfully inserted a new record.
>
> In MySQL, a field can be used this way. Are there
> any drawbacks to
> using such a field? Of course inserts will be a bit
> slower. But it is
> certainly useful in a dev environment.
>
>


=====
Shankar Nagarajan,
Flat# S10, S11, 2nd Floor,
Etinasarva-2 Apts, Begur Road,
Bommanahalli, BANGALORE, KA, IN.
Cell: 91-98454-72242




__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250