Below are MySQL tables. I need to insert values from table A's ID column to Table B's ID\_A column. Already existed values in ID\_A should be ignored. So that in the below mentioned example IDs 1 to 3 from Table A should be ignored and IDs 4 to 10 should be inserted in table B. ID\_X's value is constant i.e. 3.

What would be a single insert SQL query?

[![enter image description here](https://i.stack.imgur.com/50InQ.png)](https://i.stack.imgur.com/50InQ.png)