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');