Zeoslib Portal

Mark. "I would like to know if is it possible to know when a table have been modified (insert, delete or just update a record) for refreshing the data." I would say trigger would serve here just fine, possibly adding record to some temporary table which I can then pool from my code. Anyway...

Hi TonyG. MySQL supports triggers for a long time now. Please see the manual. DROP TABLE IF EXISTS Capital; CREATE TABLE Capital SELECT Country.Name AS Country, City.Name AS Capital, City.Population FROM Country, City WHERE Country.Capital = City.ID; delimiter // CREATE TRIGGER Capital_bi BEFORE INS...

Hi all. I am puzzled as of true nature of the problem reported, there is just not enough info provided. However, here's what you need to do to compile embedded server: o) Use at least MySQL 5.1! 5.0 has no embedded server. o) Add --with-embedded-server to your configure line There still might be som...