Inserting Data Between Tables (Duplicate Entrys)

[tomtimms]

I am trying to insert data from one table to the other, however I am having an issue that when I run my script 2 times it inserts the data twice.

 

I have columns Date | ID | Revenue | Total in my Master table and I am trying to insert Date | ID | Revenue into another table. 

 

Here is my query

$sql = "INSERT IGNORE INTO my_accounting.company_revenue (date,id,total) SELECT date,id,total FROM my_accounting.master_revenue";

 

My Master table has

Date : Index

 

And my Company Has

Date: index

id: index

total: index

 

Anyone know why I am getting double insertions?