title: How to copy multiple tables (with same columns names) to a new table <SQL>.?
body: <p>How to copy multiple tables (with same columns names) to a new table <code>&lt;SQL&gt;</code>?</p>
  
  <p>Like: </p>
  
  <pre><code>CREATE TABLE t1
  (
     p1 longtext,
     p2 longtext,
     op1 varchar
     op2 varchar,
  );
  
  
  CREATE TABLE t2
  (
     p1 longtext,
     p2 longtext,
     op1 varchar
     op2 varchar,
  );
  
  CREATE TABLE t3
  (
     p1 longtext,
     p2 longtext,
     op1 varchar
     op2 varchar,
  );
  </code></pre>
  
  <p>What I am hoping to achieve is trying to copy all the above table t1,t2,t3 into a new table new_table.
  Something like : (sql is wrong)</p>
  
  <pre><code>CREATE TABLE new_table
    AS (SELECT p1,p2,op1,op2)
        FROM t1,t2,t3);
  </code></pre>
  
  <p>Also, if I get the new table created, I am expecting every time when the tables t1,t2,t3 is updated simultaneity the new_table also gets updated. - Do i need to use a trigger for this?</p>
  
  <p>Please help me solve this.</p>