2014-07-20から1日間の記事一覧

【MySQL】INSERT SELECT で一部の値を固定にする

メモ。 INSERT INTO t_user_card SELECT null as id, id as m_card_id, name, 1 as card_level, 0 as experience, rare, attack, hp, now() as created_date, now() as modified_date FROM m_card WHERE m_card.id = ?