Run Sql file in MYSQL PHPMyadmin
Posted
by Dev
on Stack Overflow
See other posts from Stack Overflow
or by Dev
Published on 2010-05-05T11:13:01Z
Indexed on
2010/05/05
11:18 UTC
Read the original article
Hit count: 304
phpmyadmin
|mysql
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
© Stack Overflow or respective owner