MySQL duplicate/link/clone/symlink

From: ANT_THOMAS13 Aug 2016 19:53
To: ALL1 of 3
I'm not sure what the proper term is for this so I've struggled to find answers.

I want to either

a) add data to two tables at the same time, without changing any existing queries. Something that can be done in PHPMyAdmin hopefully. As if there's a setting to duplicate any new entries to TableA into TableB also.

b) "symlink" a table to another name, so one table/name points to another table. Data goes into TableA but requesting data from TableB which is "symlinked" gives you the TableA data.

Are either of those ideas possible? Or a similar alternative.
From: Peter (BOUGHTONP)13 Aug 2016 21:12
To: ANT_THOMAS 2 of 3
You want to create a view.
From: ANT_THOMAS13 Aug 2016 21:32
To: Peter (BOUGHTONP) 3 of 3
Indeed I do, works exactly how I want it to. Thanks Peter.