34,591
社区成员
发帖
与我相关
我的任务
分享
insert into class(id,classname,address)
select '1' , 'computer' , 'road' FROM dual union
select '2' , 'math' , ' park' FROM dual union
select '3' , 'music' , ' home' FROM dual ;
--这种情况貌似就应该可以了
CREATE TABLE test (
ID char(1),
VAL varchar(5)
);
INSERT INTO test
SELECT 'A', 'TRUE ' FROM dual UNION ALL
SELECT 'A', 'TRUE ' FROM dual UNION ALL
SELECT 'A', 'FALSE' FROM dual UNION ALL
SELECT 'A', 'TRUE ' FROM dual UNION ALL
SELECT 'A', 'TRUE ' FROM dual UNION ALL
SELECT 'A', 'TRUE ' FROM dual UNION ALL
SELECT 'A', 'FALSE' FROM dual UNION ALL
SELECT 'A', 'TRUE ' FROM dual UNION ALL
SELECT 'B', 'TRUE ' FROM dual UNION ALL
SELECT 'B', 'FALSE' FROM dual UNION ALL
SELECT 'B', 'TRUE ' FROM dual UNION ALL
SELECT 'B', 'TRUE ' FROM dual UNION ALL
SELECT 'B', 'FALSE' FROM dual ;