mysql within windows dos. please help!

[anthonyevans]

Dear All,

I am new to mysql and am attempting to learn using the MySQL book by Paul DuBois. I am using mysql through windows dos and am at the mysql> prompt and have typed use samp_db. All ok so far. If any of you have the book I am referring to page 42!

My problem is that the book tells me to :

'From your shell,execute the following command

%mysql samp_db < insert_president.sql'

So this is exactly what I am typing at the mysql> prompt :

mysql samp_db < c:/mysql/data/samp_db/insert_president.sql

All I get is SQL syntax errors ! I'm not sure why.

If anyone can help, I would be so grateful. It might enable me to continue with the book at more than one page an hour!!!

Thankyou,

Anthony Evans

 

[PiperA]

Try this:
First logout: mysql> quit
then: mysql>mysql -u user_name -ppassword samp_db < c:/mysql/data/samp_db/insert_president.sql

good luck

 

[NixerX]

no no no..
from the c:> mysql -u user_name -ppassword samp_db < c:/mysql/data/samp_db/insert_president.sql