CREATE TABLE `airlines` (

  `iata_code` char(2) NOT NULL,

  `airline` varchar(30) DEFAULT NULL,

  PRIMARY KEY (`iata_code`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `_airlines_new` (

  `iata_code` char(2) NOT NULL,

  `airline` varchar(30) DEFAULT NULL,

  PRIMARY KEY (`iata_code`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

insert into airlines values ('UA', 'United');

MariaDB [iflights]> INSERT LOW_PRIORITY IGNORE INTO `iflights`.`_airlines_new` (`iata_code`, `airline`) SELECT `iata_code`, `airline` FROM `iflights`.`airlines`;

Query OK, 14 rows affected, 1 warning (0.01 sec)

Records: 14  Duplicates: 0  Warnings: 1

MariaDB [iflights]> show warnings

    -> ;

+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Level | Code | Message                                                                                                                                                                                                                                                                                                             |

+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Note  | 1051 | Unknown table 'infinidb_vtable.$vtable_21'                                                                                                                                                                                                                                                                          |

| Note  | 1592 | Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave. |

+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

MariaDB [iflights]> truncate table _airlines_new;

Query OK, 0 rows affected (0.03 sec)

MariaDB [iflights]> INSERT LOW_PRIORITY  INTO `iflights`.`_airlines_new` (`iata_code`, `airline`) SELECT `iata_code`, `airline` FROM `iflights`.`airlines`;

Query OK, 14 rows affected (0.00 sec)

Records: 14  Duplicates: 0  Warnings: 0