how to automate replication within tables in phpMyAdmin?

cyberdome · 11-16-2014, 06:03 PM

how to automate replication within tables in phpMyAdmin?

I know how to replicate a table using phpMyAdmin, but how do I auto replicate a table using phpMyAdmin? for example, let us say I add 500 records/rows in table A, and it will automatically replicate those tables whitin the same database or different database, using phpMyAdmin. All database.tables will resided on the same server.

thanks in advance

Guttorm · 11-17-2014, 11:34 AM

Hi

Replication usually means hot backup to other servers. On one server, Are you looking for SQL views?

Code:

CREATE VIEW table_alias AS
SELECT * FROM some_table;