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));
解决方案 »
- 不显示删除回复显示所有回复显示星级回复显示得分回复 ADO的_RecordsetPtr类中的OPEN()函数如何使用
- mysql按某字段排序查询时,怎么样始终把某条记录放在第一个呢?
- SQL优化 ~~ 出现Using temporary; Using filesort
- MySql 怎样修改某字段的属性?使其不自动增长??
- 请教一个SQL语句
- ASP+mysql 一个奇怪的问题,希望各位多帮帮忙解决!
- 谁有MySQL++ 1.7.9 For VC++6.0 的版本
- default有什么用?怎么修改其在某column的值?
- 请教MYSQL语法出错问题
- Mysql取相同数据最大的间隔数
- 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字段