开发者

Run Sql file in MYSQL PHPMyadmin

开发者 https://www.devze.com 2022-12-29 11:37 出处：网络

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\";

相关专题：

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 le开发者_开发百科t me know is i am missing something

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

You have an extra semi column after test.

Try removing it and see if that fixes the issue.