Insert (if not exists)
 

Hi, could someone help me, how can I do:


Insert into table1 field1=x AND field2=y (if not already exist!)


:confused::confused::confused::confused::confused:

Use Insert IGNORE
1.INSERT IGNORE INTO `tablename`SET `ensembl_transcript_id` = 'ENSORGT00000000001',`transcript_chrom_start` = 12345,`transcript_chrom_end` = 12678;