CODEWITHSUNDEEP
mysql
Juan Carlos Cabotaje
Juan Carlos Cabotaje

Reputation: 57

Insert Average into table from select query

I'm trying to insert to my table an average of my select query but I am encountering an error

Here is my query:

INSERT INTO tbl_average(student_id, first_avg) VALUES 
('100', AVG(SELECT fir_grad FROM tbl_grade 
            WHERE student_id='100' AND school_year='2015-2016'))

pls help

Upvotes: 4

Views: 2264

Answers (1)

Giorgos Betsos
Giorgos Betsos

Reputation: 72195

use INSERT INTO SELECT syntax:

INSERT INTO tbl_average(student_id, first_avg) 
SELECT 100, AVG(fir_grad) 
FROM tbl_grade 
WHERE student_id=100 AND school_year='2015-2016'

Upvotes: 3

Related Questions