insert into sichuanasc(mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude)select
(mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude)
from sichuan group by adminCode
2个表,字段完全一样,第一个是 id 自增,
我需要将table1中的数据,分组排序到table2中,所以id不需要以前的id!上面的语句 报错 (Operand should contain 1 column(s));
,dzCode
,longitude
,latitude)select
(mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude)
from sichuan group by adminCode
2个表,字段完全一样,第一个是 id 自增,
我需要将table1中的数据,分组排序到table2中,所以id不需要以前的id!上面的语句 报错 (Operand should contain 1 column(s));
,dzCode
,longitude
,latitude)
select
(kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude)
from sichuan 如果mapID是自增则不要对这个字段插入数据
(mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude)
from sichuan group by adminCode
SQL语句有问题,不是标准的SQL格式
select
(mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude)
from sichuan group by mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude
我猜是不是这个原因啊。插入的时候 id字段要插入null?但是我把null加在哪啊?
,dzCode
,longitude
,latitude)
select (mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude)
from sichuan order by adminCode asc
mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude
from sichuan group by mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude
能否运行?
,dzCode
,longitude
,latitude)
select
mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude
from sichuan group by mapID,kind,name,py,exonym,city,street,zipCode,address,phone,adminCode
,dzCode
,longitude
,latitude不能运行啊!
第二个SQL语句多了mapID字段