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

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

How To See The Results Into An Output File

2003-03-20 Thread Yasen Petrov
Hello, when I try mysql> select * from member; it shows lots of records and the screen goes up quickly. Thus I can't see the results very well because of the small screen (only 19" :):):) and I wonder if there's a way to output the results into a .txt file. why not be like: mysql> use samp_db m