Description files

[knickerlas]

Hi everyone,
Could someone tell me how to use a 'prewritten description file' from start to finish, including where to store the folder containing the files and how to invoke them´?

Many thanks

Nick

[[deleted]]

It depends on what you mean by "rewritten description files"

[knickerlas]

Well I have a tutorial with a bunch of files that look a little like php scripts for entering data into a database in php/mysql.

Here's one of the files:

(create_president.sql)

Create president table for US Historical League

DROP TABLE IF EXISTS president;
CREATE TABLE president
(
last_name VARCHAR(15) NOT NULL,
first_name VARCHAR(15) NOT NULL,
suffix VARCHAR(5) NULL, / name suffix (Jr., II, etc.) /
city VARCHAR(20) NOT NULL,
state VARCHAR(2) NOT NULL,
birth DATE NOT NULL,
death DATE NULL
);

[[deleted]]

These are SQL scripts (yes, you can script in SQL)
They are meant to be run by MySQL presumably.
If you are on linux all you have to do is run:

mysql database_name <script_name.sql

[knickerlas]

Thanks Vincent.
If I have these in a folder in the same directory as mysql do I input

mysql database_name < The Folder/script_name.sql

and how would I do this if I was already in the mysql program?

Cheers

Nick

[[deleted]]

I think it may be wise for you to have a look at the MySQL manual :-)
many things are explained there.

[Anon]

Hi Vincent
I have been searching the manual but can't find it.
In what catagory would it be listed?

Nick

[[deleted]]

http://www.mysql.com/doc/B/a/Batch_mode.html