anthonyevans
Technical User
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
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