Table1 ID is auto increment and i also want to store the information from table 2 against that auto generated ID
You want to update field ID and set to 10?

Some sample:

UPDATE test.personal_info
SET ID = '10'
WHERE db1.table1 = db2.table2


OR

 UPDATE test.personal_info
 SET ID = '10'
 ON &lt;DB.TABLE&gt;
 JOIN TABLE1.FIELD = DB.TABLE2.FIELD