mysql:插入另一个表中的值

Question

我有 3 张 table

Player: player_id, player_name

Date: date_id, date_value

PlayerOnDate: pod_id, player_id, date_id

我如何插入类似的内容

INSERT INTO `playerondate`(`player_on_date_id`, `player_id`, `date_date_id`) VALUES (
  NULL,
  SELECT player_id 
    WEHRE player_name LIKE 'aName',
  SELECT date_id 
    WEHRE date_value LIKE '12122015'
)

Answer 1

有一个特定的 SQL 语句用于 INSERT INTO ... SELECT

INSERT INTO `playerondate`(`player_on_date_id`, `player_id`, `date_date_id`)
SELECT NULL, player_id, date_id 
FROM playerondate
WHERE player_name = 'aName' AND date_value LIKE '12122015'