Select inside an insert that returns a number?

[onedumbcoder]

is it possible to have a select inside of a insert that will return a numbeR?

 

for example I have lets say a table called animal with the following data

 

id  type

1    cow

2    bird

3    fox

4    cow

 

 

can i do something like this

 

INSERT INTO barn(animal, count)  VALUES('cow', (SELECT COUNT(id) FROM animal WHERE type='cow'))

 

[kickstart]

Hi

 

That works.

 

All the best

 

Keith