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));
解决方案 »
- 新手求推荐Mysql的书
- 在iframe 框,怎么能够让iframe 中的提示框在整个页面查看,而不是只是在那个框中
- 如何将一PC上的mysql数据库数据传递到另一PC上的mysql数据库中
- mysql数据恢复,急!
- 跪求MySQL查询语句
- insert 产生的是行级还是表级别的表
- Show Index 与 information_schema.statistics
- 请教一个SQL编程的问题
- linux 上新安装了lamp 测试php apache mysql 都正常。但是我安装了dedecms 也能安装成功。但是安装完就打不开网站了。500错误
- 求sql语句
- postgres的备份问题
- 一个需求sql不太会写
,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字段