Will MySQLWorkbench produce only MySQL 5.0 compatible scripts?
Posted by:
Al P
Date: December 09, 2008 07:50PM
This is probably a stupid question but I want to understand clearly.
Will MySQLWorkbench produce only MySQL 5.0 compatible scripts?
I designed a schema and exported it with forward engineer SQL create script.
I am trying to import this into Yahoo web hosting.
The Yahoo web hosting environment supports only MySQL 4.1.14 and phpMyAdmin 4.3.11
I get the following when importing:
Error
SQL query:
SET @OLD_SQL_MODE = @ @SQL_MODE ,
SQL_MODE = 'TRADITIONAL';
MySQL said:
#1231 - Variable 'sql_mode' can't be set to the value of 'TRADITIONAL'
If I replace the traditional mode with ANSI, also on the import filter, then it fouls up at some later statements.
So my basic question is, will MySQLWorkbench produce only MySQL 5.0 compatible scripts? Thanks.
Subject
Views
Written By
Posted
Will MySQLWorkbench produce only MySQL 5.0 compatible scripts?
3479
December 09, 2008 07:50PM
2358
January 15, 2009 10:46AM
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.