<div>
USE INSERT TRIGGER<br />
<a href="http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html" rel="ugc">http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html</a><br />

<pre><code id="code-297388">delimiter | 
CREATE TRIGGER yourTrigger AFTER INSERT ON tab1
  FOR EACH ROW BEGIN
    INSERT INTO table2 SET col1 = NEW.co1, col2 = NEW.co2;
    INSERT INTO table3 SET col1 = NEW.co1, col2 = NEW.co2;
  END;
|</code></pre>
</div>


USE INSERT TRIGGER
http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html [http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html]


delimiter | 
CREATE TRIGGER yourTrigger AFTER INSERT ON tab1
  FOR EACH ROW BEGIN
    INSERT INTO table2 SET col1 = NEW.co1, col2 = NEW.co2;
    INSERT INTO table3 SET col1 = NEW.co1, col2 = NEW.co2;
  END;
|

<div>
<div class="content wysiwyg-content">
I am trying to get a list of all the inserted records into a table. The records that are getting inserted &nbsp;into the current table is via a select query that groups records from another table and inserts them into the current table.<br />
<br />
Once I get all the newly inserted record I want to insert them into a 3 table.<br />
<br />
<br />
<br />

</div>
</div>


I am trying to get a list of all the inserted records into a table. The records that are getting inserted  into the current table is via a select query that groups records from another table and inserts them into the current table.

Once I get all the newly inserted record I want to insert them into a 3 table.





how to get a list of inserted record in a table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.