如何在mysql中将数据插入子表

Question

我有两个表，一个文章和一个摘要表。

摘要表是文章表的子表，我想通过文章表将数据添加到摘要表中。

汇总表的sql如下：

  CREATE TABLE summaries(
   summary_id INT NOT NULL AUTO_INCREMENT,
   article_id INT,
   summary TEXT,
   PRIMARY KEY(summary_id),
   FOREIGN KEY(article_id) REFERENCES articles(article_id)
  )ENGINE=INNODB;

如何将摘要添加到摘要表中，并使article_id等于我的文章表中的article_id？

下面是我如何将数据保存到文章表中：

 $sql = "INSERT INTO articles  (url, domain, favicon, title) VALUES ( '$url','$domain','$favicon','$title')";
    if (mysql_query($sql)){
        $s = "SELECT max(article_id) from articles"; 
        $object1 = mysql_query($s);
    }

这是我想要做的：

       $large_summary = $article_array['summary'];
       foreach ($large_summary as $summary){
          // $summary_sql = "INSERT INTO summaries SET `summary`=(SELECT `sum`.`summary` FROM summaries as sum, articles as art WHERE art.article_id=sum.article_id AND art.article_id=$object1 -> article_id)";
        $summary_sql = "INSERT INTO `summaries` (summary,article_id) VALUES ('$summary' , ('SELECT article_id FROM articles WHERE article.article_id=summary.article_id AND article.article_id = $object1 -> article_id' ))";
        echo $summary_sql;
        $summary_sql_query = mysql_query($summary_sql);

    if(!mysql_query($sql2)){
      die('Error: ' . mysql_error());
    }
        echo "$summary <br>";
    }

我循环遍历large_summary数组，以获得一个单独的摘要，我希望通过文章将其保存到数据库中

Answer 1

INSERT INTO summaries SET `summary`=
(SELECT `art`.`summary` FROM summaries as sum, articles as art WHERE
art.article_id=sum.article_id AND art.article_id=123)

Here '123' is a sample article_id i am passing. You have to pass your real article_id

Answer 2

试一试：

INSERT INTO `summaries` (summary,article_id)
    VALUES ($yoursummryVar , (SELECT article_id 
                              FROM articles
                              WHERE ........)
    )