mysql - 在 INSERT INTO 查询中使用多个 SELECT

Question

我尝试在查询中插入一些带有多个选择的值，但它在 where 子句错误中给了我未知的列“rate”

   INSERT INTO oc_tax_rule (tax_class_id, tax_rate_id, based, priority)
    VALUES (
    (SELECT tax_class_id FROM oc_tax_class WHERE title LIKE '%0%'),
    (SELECT tax_rate_id FROM oc_tax_rate WHERE rate ='0'),
    'store', 1)

Answer 1

您可能正在寻找这个:

INSERT INTO oc_tax_rule (tax_class_id, tax_rate_id, based, priority)
SELECT
  (SELECT tax_class_id FROM oc_tax_class WHERE title LIKE '%0%' LIMIT 1),
  (SELECT tax_rate_id FROM oc_tax_rate WHERE rate ='0' LIMIT 1),
  'store',
  1

选择查询将仅返回一行，第一列和第二列是两个选择查询的结果 - 您可能需要添加 LIMIT 1 以确保只返回一行