insert into ... select 中不用加values,比如
INSERT INTO Customers (CustomerName, Country)SELECT SupplierName, Country FROM SuppliersWHERE Country='Germany';
语法错误insert into table1 (c1,c2……)select c1,c2…… from table2没有values关键字 select 也没有括号