表中相同的合并成一行

[hustar]

如表a
name cost
A 1
B 2
C 3
A 4
B 5
A 6
用mysql怎么样把相同name的cost相加，和其它的行变成一个新表b
name cost
A 11
B 7
C 3

[-狙击手-]

select name,sum(cost)
into b
from a
group by name

[-狙击手-]

select name,sum(cost) as cost
into b
from a
group by name

[孤独加百列]

SELECT name,SUM(cost)
FROM 表a
GROUP BY name
INTO 表b

[raymonshi]

[Quote=引用 2 楼 的回复:]

select name,sum(cost) as cost
into b
from a
group by name
[/Quote]
正解。
insert into b(name,cost)
select name,sum(cost) as cost
from a
group by name

[开着拖拉机泡妞]

select 
name,sum(cost) as cost
into b
from a
group by name

[孤独加百列]

[Quote=引用 3 楼 的回复:]

SQL code

SELECT name,SUM(cost)
FROM 表a
GROUP BY name
INTO 表b
[/Quote]

手太快，粘错地方了

SELECT name,SUM(cost) AS COST
INTO 表b
FROM 表a
GROUP BY name