How to get the date of the last update of the database?

asantos

Hello.

Do you know if there is a function or query that shows me the date/time of the last update, insert or delete of a record in a certain database?

Thanks in advance

pbmods

By default, no. However, you can set this up by creating a last_updated (or whatever you want to call it) field and use a trigger to automatically touch this every time a row is updated.

Expand|Select|Wrap|Line Numbers

 
delimiter |

CREATE TRIGGER `setUpdateTimestamp` BEFORE UPDATE ON `tablename` 

 FOR EACH ROW

  BEGIN

   SET NEW.`last_updated` = NOW();

  END;|

delimiter ;

sivadiuday

Quote:

Originally Posted by asantos

Hello.

Do you know if there is a function or query that shows me the date/time of the last update, insert or delete of a record in a certain database?

Thanks in advance

Hi dear .... I too got stuck with this ... so pls send me reply to <Removed>or hear.... ThanQ in advance dear............

mwasif

Quote:

Originally Posted by pbmods

By default, no. However, you can set this up by creating a last_updated (or whatever you want to call it) field and use a trigger to automatically touch this every time a row is updated.

Expand|Select|Wrap|Line Numbers

 
delimiter |

CREATE TRIGGER `setUpdateTimestamp` BEFORE UPDATE ON `tablename` 

 FOR EACH ROW

  BEGIN

   SET NEW.`last_updated` = NOW();

  END;|

delimiter ;

What about creating a timestamp field?

pbmods

Quote:

Originally Posted by mwasif

What about creating a timestamp field?

LOL or instead of any of my complicated ideas, you can use a timestamp field whose default can be set to... CURRENT_TIMESTAMP :P

Only the timestamp type does this, though, which is curious.

How to get the date of the last update of the database?

re: How to get the date of the last update of the database?

re: How to get the date of the last update of the database?

re: How to get the date of the last update of the database?

re: How to get the date of the last update of the database?

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about