can't run a recent SQL script on MySQL4
Posted by:
joão ramos
Date: February 09, 2009 08:00AM
so I've created this recent SQL script from a MySQL Workbench diagram but, when I tried to run the script on my MySQL4 server, it returned me this error:
Error
SQL Command:
SET @OLD_SQL_MODE = @ @SQL_MODE ,
SQL_MODE = 'TRADITIONAL';
MySQL Messages : Documentation
#1231 - Variable 'sql_mode' can't be set to the value of 'TRADITIONAL'
I guess it's because I'm trying to run a recent SQL script in a old MySQL4 server (mediatemple refuses to upgrade my MySQL to the 5th).. any suggestions on this?
Subject
Views
Written By
Posted
can't run a recent SQL script on MySQL4
3724
February 09, 2009 08:00AM
2380
February 09, 2009 12:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.