If I have two tables:
Table A - INNODB table
Table B - MEMORY table
Is it possible to have Table B mirror Table A using just MySQL? If so, how?
I'm not sure what else could be meant. I simply wish for all rows to appear in Table B, much like how replication works with whole databases.
Table B = Table A