1INSERT INTO table_listnames (name, address, tele)
2SELECT * FROM (SELECT 'Unknown' AS name, 'Unknown' AS address, '022' AS tele) AS tmp
3WHERE NOT EXISTS (
4 SELECT name FROM table_listnames WHERE name = 'Rupert'
5) LIMIT 1;
1INSERT INTO table_name (firstname, lastname)
2SELECT 'NEW FIRSTNAME', 'NEW LASTNAME'
3FROM DUAL
4WHERE NOT EXISTS(
5 SELECT 1
6 FROM table_name
7 WHERE firstname = 'NEW FIRSTNAME' AND lastname = 'NEW LASTNAME'
8)
9LIMIT 1;
1INSERT IGNORE INTO companies
2 (id, full_name, address, phone_number)
3VALUES
4 (1, 'Apple', '1 Infinite Loop, Cupertino, California', 18002752273);
5
1INSERT IGNORE INTO `transcripts`
2SET `ensembl_transcript_id` = 'ENSORGT00000000001',
3`transcript_chrom_start` = 12345,
4`transcript_chrom_end` = 12678;