MySQL insert into where 去重复

这儿有一个order表，脚本我放在最后，
我想在insert之前判断order_name是否存在，不存在则保存，存在则不保存。
但是MySQL insert语句是不能跟where子句的，像这样：

INSERT INTO `order` (order_name) VALUES ('订单3') WHERE NOT EXISTS (SELECT order_id FROM `order` WHERE order_name = '订单3');

会报错，

INSERT INTO `order` (order_name) VALUES ('订单3') WHERE NOT EXISTS (SELECT order_id FROM `order` WHERE order_name = '订单3')
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE NOT EXISTS (SELECT order_id FROM `order` WHERE order_name = '订单3')' at line 1
> 时间: 0s

我们可以修改成insert select语句：

INSERT INTO `order` (order_name) SELECT '订单3' FROM DUAL WHERE NOT EXISTS (SELECT order_id FROM `order` WHERE order_name = '订单3');

这样就能实现我们的需求。

SQL脚本

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order`  (
  `order_id` int NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `order_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单名称',
  `order_amount` int NULL DEFAULT NULL COMMENT '订单金额',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of order
-- ----------------------------
INSERT INTO `order` VALUES (1, '订单1', 70);
INSERT INTO `order` VALUES (2, '订单2', 80);
INSERT INTO `order` VALUES (3, '订单3', 90);