Will MySQLWorkbench produce only MySQL 5.0 compatible scripts?
Posted by:
Al P
Date: December 09, 2008 06:26PM
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?
2556
December 09, 2008 06:26PM
1592
December 09, 2008 07:49PM
1710
December 10, 2008 11:17AM
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.