[MySQL,SQLite]INSERTで複数のデータを挿入|ktyr report

[MySQL,SQLite]INSERTで複数のデータを挿入

2014-04-02

INSERTで複数のデータを挿入

INSERT INTO system_table (name,gender) SELECT 'jeff' AS name, 'male' AS gender UNION ALL SELECT 'pola', 'female';

MySQL or SQLite(バージョン 3.7.11以降)

INSERT INTO system_table (name,gender) VALUES ('jeff','male'),('pola','female');