MySQL Forums
Forum List  »  Newbie

Working with script files in MySQL
Posted by: Avinash Subramanya
Date: April 20, 2005 08:05AM

How to use script files in MySQL similar to what we do in Oracle? How to define variables in MySQL script files?

For example if the following is my Oracle sql script file:

DEFINE data_tablespace=test_dat1
DEFINE index_tablespace=test_idx1

DEFINE install_schema=test
DEFINE password=test

--Define Script ROOT
DEFINE script_root="c:\tmp\scripts"

@ &script_root\tables\tables.sql
@ &script_root\constraints\cons.sql
@ &script_root\sequences\seq.sql
@ &script_root\indexes\index.sql

what would be the equivalent script for MySQL? Any tutorial would be of great help.

TIA.

Options: ReplyQuote


Subject
Written By
Posted
Working with script files in MySQL
April 20, 2005 08:05AM


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.