搜题
问题   更新时间2023/11/1 17:34:00

存在两个结构相同的数据库表T1(col1,col2,col3)、T2(col1,col2,col3),写出一SQL语句将所有T1数据导入到T2表()。

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

王老师:19139051760(拨打)