注意：此页面搜索的是所有试题
题目内容
（国家开放大学MySQL数据库应用）
存在两个结构相同的数据库表T1(col1,col2,col3)、T2(col1,col2,col3),写出一SQL语句将所有T1数据导入到T2表 (D )
A.select col1,col2,col3 from T1 INTO T2 (col1,col2,col3)
B.INSERT T1 (col1,col2,col3) INTO T2(col1,col2,col3)
C.insert into T2 (col1,col2,col3) AS select col1,col2,col3 from T1
D.insert into T2 (col1,col2,col3) select col1,col2,col3 from T1
A.select col1,col2,col3 from T1 INTO T2 (col1,col2,col3)
B.INSERT T1 (col1,col2,col3) INTO T2(col1,col2,col3)
C.insert into T2 (col1,col2,col3) AS select col1,col2,col3 from T1
D.insert into T2 (col1,col2,col3) select col1,col2,col3 from T1
参考答案