Well for starters in the UPDATE statement the the SET section is backwards it should be
SET col = @count
and you haven't declared the
@count
variable, not sure if this last part matters in MySql though.
However something else to try is
this[
^].
Or see if this, which is just from the link, works.
UPDATE DB2.TBL2 a, DB1.TBL1 b
SET a.col= COUNT(b.col)