Running mySQL queries from a script

Question

For my database class the teacher assigned us to use Oracle SQL to design an application. Because I have more experience with mySQL he said I could use it instead.

I want to make my assignment look as simliar to his example as possible. What his example consists of of is one file run.sql that looks like this:

@start //this runs start.sql which creates the tables

DESC table_name; //do this for all tables

@insert //this runs insert.sql that creates dummy data

SELECT * FROM table_name; //do this for all tables

@query //this runs query.sql that runs our sample queries

@drop //this kills all the data

Is there a way to do something simliar?

Namely a way to write a query that calls external queries and outputs all data to an output.txt file?

ChrisSM · Accepted Answer · 2013-05-01 03:00:50Z

1

Use 'source' to input the *.sql files

use 'create procedure' to generate the 'drop' function

use "into outfile '/file/path';" on your select to write out.

double redirect to append: "into outfile '>>/file/path';"

answered May 1, 2013 at 3:00

ChrisSM

905 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dspiegs Over a year ago

Is there a way to do something like this? SOURCE run.sql INTO OUTFILE 'output.txt';

dspiegs Over a year ago

I found this works: mysql -p dbname < foo.sql > foo.txt but doesn't contain all output or pretty print.

tadman · Accepted Answer · 2013-05-01 02:55:08Z

0

The source command for the mysql command-line client could do the job here:

source start.sql;

DESC table_name;

You can get more commands with help.

answered May 1, 2013 at 2:55

tadman

212k23 gold badges237 silver badges266 bronze badges

2 Comments

dspiegs Over a year ago

that worked! now just to figure out how to get it to print output

tadman Over a year ago

It should display the output of any queries it runs by default. If you need formatting, looks like @ChrisSM has you covered.

Collectives™ on Stack Overflow

Running mySQL queries from a script

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related