mysql_query() cannot execute multiple sql statements in one go. Period.
mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier.
You can use multiple
mysql_query() calls, one for each statement. But before doing this, see the next point.
Pls do not use mysql_*() functions, they have been deprecated for years and have been removed from php 7.0. Use mylsqi or PDO instead.
Warning This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information.