sandyssn

hey all,
one more query!
Is there a way to clone dynamic table? I mean to say that I do 'show create table' and 'create table alias-name' and then 'insert option' but they result only in giving me data currently present in the table. My requirement is a table which keeps on adding values in the cloned table as and when I add data to the original table .. Now as a good database programmer you are supposed to use data in a cloned table for all your operations going back to the basics right !

Well I'm not very much familiar with replication concepts and all I know about it is replication is used for long-distance and different servers! Can it be implemented here pertaining to this context in the same server which more or less performs like a dynamic cloned table is what I name it? :p