一条insert语句插入数据库 柔情只为你懂 2021-11-11 03:14 276阅读 0赞 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
还没有评论,来说两句吧...