MySQL code generation

[alexander.gra...@student.unisg.ch]

Hello,

I just started working with RISE. I have now created a model which I want to export as MySQL-code. The code should be used either with phpmyadmin or the MySQL workbench.

However, when I try to run the code produced by the MYSQL-generator I always encounter errors like (even when I call the code with the MySQL-command line toolö):

-Error 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 GO....

I think this problem is somehow revolving around the DELIMITER statement in the first lines. Does anybody have an idea of how to transfer the code generated by RISE into a compliant version?

Thank you!

[HOlsen]

The script consists of multiple statements that must be executed on
the same database connection. The script is intended to be used with
the MySQL Command-Line tool which implements the DELIMITER concept and
executes the statements on the same connection. RISE also implements
the delimiter concept and executes the statements on the same
connection. This means that you can enter the connection string to
your database in the code generator form in RISE and click the Update
Database button to update your database.

Best regards,
RISE to Bloome Software

[rnrstar]

I found that the easiest way for me to do this was to use the mysql
client. To start the mysql client I used...

mysql -u username -p databaseName

Once at the mysql prompt I would enter the following...

\. sql_file_created_by_rise

Make sure the file is in the same folder that you are running mysql
from and you won't have any path issues.

Todd

[gyd...@gmail.com]

Didn't work for me. :( .. rise generator can upload to localhost client such: xampp or wamp??

[Hender Ruiz]

just need refactor all de quotes ("), the script is not utf8, so just find and replace