Home > Backend Development > PHP Tutorial > mysql导出文件有关问题?请!

mysql导出文件有关问题?请!

WBOY
Release: 2016-06-13 13:12:46
Original
869 people have browsed it

mysql导出文件问题?请高手指点!!!
mysql> select version();current_date;
+------------------+
| version() |
+------------------+
| 5.1.36-community |
+------------------+
1 row in set (0.00 sec)

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 'curre
nt_date' at line 1
mysql> select version();current_date;
+------------------+
| version() |
+------------------+
| 5.1.36-community |
+------------------+
1 row in set (0.00 sec)

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 'curre
nt_date' at line 1
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| metinfo |
| mysql |
| newnetinfo |
| test |
+--------------------+
5 rows in set (0.00 sec)

mysql> mysqldump -u root -p test>d:\test.sql;
Outfile disabled.
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 'mysql
dump -u root -p test>d:est.sql' at line 1
mysql>

我查看了是5.1.36 版本的mysql,请问怎么样才导出成功,是不是版本问题?是怎么解决的昵?谢谢!!!

------解决方案--------------------
mysqldump是在命令行下执行的。。。
------解决方案--------------------
系统命令行下 比如win的dos

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template