MySQL 5.5 execution of sql file using "source"

[John McCulloch]

Greetings,

I'm trying to execute a sql file in the command line for sql 5.5 on a windows 7 computer. My sql file is on my c drive in the directory "john". My sql file is named mysql-start.sql. How do I execute the source command to run this sql file? This is something I am learning from a free online database class from Stanford. Here is how the class suggests I do this:

To try executing a SQL file from the command-line shell, download the starter script, place it somewhere that you can easily remember the file path, and type the following at the prompt (where ~PATH~ represents the path to the file):

mysql> source '~PATH~/mysql-start.sql'

I have tried the above to no avail.Any help is greatly appreciated,

John M

[johny10151981]

The statement is

mysql> \. c:/john/mysql-start.sql

before you do you should read link first

[John McCulloch]

Thanks for the reply!

I tried \. c:/john/mysql-start.sql , and i get "error 1046 <3D000>: No database selected". Here are the contents of the mysql-start.sql file:
drop table if exists T;
create table T (A text, B text);
insert into T values ('Hello,', 'world!');
select * from T;

Thanks again! Any ideas?

John M

[Rabbit]

Well, from the error, it sounds like you didn't select a database. You can't run SQL without selecting a database first.