WampServer

I and my friend use different edition of wamp server.When he exports the sql to me,I find that I can't import the sql to my mysql.It says" #1064 - 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 'phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"' at line 1"
How to solve this problem?

Hi,

Set sql_mode to none in both environments.
Left-clic wampmanager tray icon -> MySQL -> MySQL settings -> sql_mode -> sql_mode->none

Which corresponds, in the my.ini file to:

sql-mode=""

Warning : If there is no line or if it is commented, it corresponds to the default mode_sql whose values are different in terms of the MySQL versions.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons