插入从另一个表计算的值 [英] insert a value calculated from another table

问题描述

我想做一个查询，以插入从另一个表开始计算的值.我不想使用临时表，我想在一个单一查询中完成所有事情.有可能吗?

I would like to do a query for inserting a value calculated starting upon another table. I don't want to use Temporary tables and I would like to do everything in one singel query. It is possible?

我在下面尝试了这个，但它不起作用.

I tried this one below but it doesn't work.

谢谢

AFeG

INSERT INTO MyTable( `DATE`, `Name`, `Total` ) 
VALUES ( 
 '2010/01/01',
 'Thunder',
  SELECT SUM(aValue) FROM AnotherTable
)

推荐答案

INSERT  
INTO    MyTable( `DATE`, `Name`, `Total` ) 
SELECT  '2010/01/01', 'Thunder', SUM(aValue)
FROM    AnotherTable

这篇关于插入从另一个表计算的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！