title: How to insert into values into two table with foreign key relationship built in?
body: <p>The 2 table structures like the following(generated by <code>sequel pro</code>):</p>
  
  <p>The question table:</p>
  
  <pre><code>CREATE TABLE `question` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(128) NOT NULL DEFAULT '',
    `content` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>The answer table:</p>
  
  <pre><code>CREATE TABLE `answer` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `question_id` int(11) unsigned NOT NULL,
    `content` text NOT NULL,
    PRIMARY KEY (`id`),
    KEY `question_id` (`question_id`),
    CONSTRAINT `answer_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>Now when I want to insert an answer:</p>
  
  <p>Can I do something like:</p>
  
  <p>INSERT INTO answer(<code>content</code>) JOIN question(<code>title</code>,<code>content</code>) VALUE('Ironman',"favourite characters","Who is your favourite characters in Avanger?");</p>
  
  <p>or Is there a better way to do the similar thing?</p>