一条insert语句插入数据库

CREATE TABLE test_main (
  id      INT   NOT NULL,
  value   VARCHAR(10),
  PRIMARY KEY(id)  
);

oracle插入方式：
INSERT INTO test_main(id, value) 
SELECT 1, 'ONE' FROM dual  UNION  ALL
SELECT 2, 'TWO' FROM dual;


mysql、postgresql插入方式：

INSERT INTO test_main(id, value) values(1,'one'),(2,'two'),(3,'three');

转载于:https://www.cnblogs.com/wshsdlau/p/5620198.html