RE: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Paul DuBois
At 21:21 +0100 3/19/03, Yasen Petrov wrote: how to ececute it from dos prompt as long as I have to connect to mysql first. so i'll have mysql prompt anyway. please give me a better explanation. thank you Uh, sorry. Apparently you didn't even *try* to use the instructions given, so I will just repe

RE: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Yasen Petrov
how to ececute it from dos prompt as long as I have to connect to mysql first. so i'll have mysql prompt anyway. please give me a better explanation. thank you - Before posting, please check: http://www.mysql.com/manual.php

RE: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Tab Alleman
Hehe.. I just got past this problem and on to the next. You need to make sure you are executing the command from a DOS prompt..the response you got indicates (I'm pretty sure) that you are executing it from a mysql> prompt (ie: a mysql client prompt). Yasen Petrov wrote: > Hello, > > I'm using W

Re: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Joe Lewis
I know DOS doesn't have a "cat" command, so try : type create_president.sql > samp_db Or have I been out of the DOS world too long? Joe 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

Re: Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Paul DuBois
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_presid

Can't Load Data Into The Database With "<" Operator

2003-03-19 Thread Yasen Petrov
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 highl