Convert SQL Server Query to MySQL
What do I need to do to convert this query to work within in MySQL?

Thank you for help.
Code:
[SQL] DECLARE
        @CountOfEmp INT = (
                SELECT
                        COUNT (*)
                FROM
                        names
        )

  
;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE
        @CountOfEmp INT = (
                SELECT
                  ' at line 1