At 20:57 +0100 3/19/03, Yasen Petrov wrote:
>Hello,
>
>I'm using Win98 OS and MySQL 3.23.39-max. Now, I'm trying to load data from
>the DOS Prompt into a new database (samp_db):
>
>samp_db < create_president.sql
>
>and it returns ERROR 1064: you have an error in your sql syntax near
>'samp_db < create_president.sql' at line 1
>
>Any ideas will be highly appreciated.
You're running this from within mysql. Run this command from the
DOS prompt:
C:\> mysql samp_db < create_president.sql
Or else run this command:
C:\> mysql samp_db
and then within mysql use this command:
mysql> SOURCE create_president.sql;
--
Paul DuBois
http://www.kitebird.com/
sql, query