読者です 読者をやめる 読者になる 読者になる

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

MySQL

メモ。

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 = ?