Re: New data entered in table

[Peter Brawley]

> 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.