Select in the middle of an INSERT query?

Question

MySQL

Good morning.
Wrote sql request but does not plow.

INSERT INTO `tab`(`order`,`type`) VALUES ((SELECT count(*) FROM `tab` WHERE `type`=1)+1,1)

#1093 - It is not allowed to specify the table 'tab' in the list of tables FROM to make changes to it

But why?
thanks for answers

Answer 1

INSERT INTO `tab` (`order`, `type`) SELECT COUNT(*)+1, 1 FROM `tab`