469,590 Members | 2,344 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,590 developers. It's quick & easy.

About MySQL scripts

Hi,
I am new to MySQL. I want to create a script file which will include a
number of commands and execute it, just like we do in Oracle. Can any
one tell me how to do it?
Suppose I want to create a script called "temp" that will contain say 4
create statement. I want someone to show me how to create that file and
execute it. And how to capture the output in a separate file like we do
in Oracle. And what should be the extension of the souce file.

Thanks.

Apr 1 '06 #1
1 1929
Karuna wrote:
Hi,
I am new to MySQL. I want to create a script file which will include a
number of commands and execute it, just like we do in Oracle. Can any
one tell me how to do it?
The MySQL software comes with a utility that serves as both an
interactive shell (analogous to Oracle's SQL*Plus) and a tool to run
scripts containing SQL commands.

Read this documentation page and its sub-pages:
http://dev.mysql.com/doc/refman/5.0/en/mysql.html

Specifically, executing SQL script files is documented here:
http://dev.mysql.com/doc/refman/5.0/...-commands.html
http://dev.mysql.com/doc/refman/5.0/en/batch-mode.html
Suppose I want to create a script called "temp" that will contain say 4
create statement. I want someone to show me how to create that file and
execute it. And how to capture the output in a separate file like we do
in Oracle.
You can capture output just like any other command at the shell level,
with the ">" output redirection feature.

You can also use the "tee" command in your script to specify the output
file.
http://dev.mysql.com/doc/refman/5.0/...-commands.html

You can also use the --tee='filename' option to the mysql command.
Options are documented here:
http://dev.mysql.com/doc/refman/5.0/...d-options.html

Create the file with a text editor. Alternately, create the file by
capturing the output of MySQL's "mysqldump" command-line tool, which
serves as a database backup utility. The output of mysqldump is a SQL
script that contains the CREATE and INSERT commands necessary to
recreate a database. You can run this script with the 'mysql' utility
as described above.
And what should be the extension of the souce file.


The extension is not important. My habit is to use ".sql", but the
mysql client utility doesn't require any specific extension on the file.

Regards,
Bill K.
Apr 1 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by David | last post: by
reply views Thread by Enrique Sanchez Vela | last post: by
2 posts views Thread by Sean Berry | last post: by
2 posts views Thread by adnan alsamari | last post: by
3 posts views Thread by Yevgeny Ioffe | last post: by
1 post views Thread by Lennie De Villiers | last post: by
7 posts views Thread by Paul | last post: by
22 posts views Thread by Sandman | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.