First off... there is a space between the -u and the username (it might
work without it, haven't tried).
You don't have to put a dabase name before the < as long as there is
something in the SQL file you're feeding MySQL. Make a
CREATE DATABASE temp;
USE DATABASE temp;
sql here
sql here
sql
That's a good question and I need some help related to the same too.
Usually I create scripts like:
createSequences.sql,
createTableX.sql,
createTableY.sql,
populateTableX,etc..
that are called by a script called makeDB.sql
The way I run it in Oracle is:
sqL> @makeDB
How can I do the same wi
Might be a case of the blind leading the blind here (list folks: please
correct me if I'm way off base ...)
I believe that one way to do this would be to create a file with any SQL
commands you want to run and then redirect it to mysql via back ticks:
`mysql -uroot < sql_command_file`;
Normally
