MySQL Forums
Forum List  »  Newbie

Re: New data entered in table
Posted by: Peter Brawley
Date: November 10, 2018 12:24PM

> how does MySQL alert the UI that there is a new piece of data.

It doesn't because (i) MySQL isn't built on the Windows design ethos of everything promiscuously linked to everything else, (ii) an RDBMS doing such would give it a huge security hole).

> Surely the UI doesn't keep track of that.

If you want that info, you'll need to code it into the UI, eg (i) in the DB every update insert and delete has a Trigger that writes to a semaphore table, (ii) the UI checks the semaphore table as often as it wants for new semaphore rows.

Options: ReplyQuote


Subject
Written By
Posted
November 10, 2018 08:58AM
November 10, 2018 10:47AM
Re: New data entered in table
November 10, 2018 12:24PM
November 10, 2018 01:13PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.