Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?()
- A、INSERT INTO tab1 SELECT cx, cy FROM tab2
- B、INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
- C、INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
- D、INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
正确答案:A
答案解析:有
微信扫一扫手机做题