scripts/network.sql

UPDATE network_table T
   SET T.gene_i1 = 
     (SELECT gene_i
     FROM gene_info A
     WHERE concat(A.gene_id,".0") = T.gene_id1)