Run Sql file in MYSQL PHPMyadmin

Question

Hi All,

I have written the SQL file with on excecuting it is throwing the error as 

mysql> @"C:\Documents and Settings\Hemant\Desktop\create_tables.sql"; ERROR 1064 (42000): 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 '@"C:\ Documents and Settings\Hemant\Desktop\create_tables.sql"' at line 1

on line 1 code is CREATE DATABASE IF NOT EXISTS test; DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE test;

please let me know is i am missing something

Answer 1

Correct me if I'm wrong, but isn't there a table test by default when you setup PHPMyAdmin?

Answer 2

Extra semi column after test