我先进入我的数据库(use netshop;)然后用(source d:\goods.sql;)结果第一次行了,然后我又导入另一sql脚本,(source d:\orders.sql;)结果就不行了,总是什么无法识别(rders.)[少了个o],怀疑是路径(d:\)的问题,我又把刚才导入的goods数据删了,重新运行(source d:\goods.sql;)结果还是不行。然后我把goods.sql和orders.sql放在mysql目录的bin下面直接(source goods.sql;)又完全能成功,不会是输入法引起的吧?求大虾解决。
mysql> select order from order;
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 'order
from order' at line 1
mysql>
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 315
Server version: 5.1.41-community MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> use netshop;
Database changed
mysql> source D:\goods.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 'sourc
e D:' at line 1
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 'oods.
sql' at line 1
mysql>