Re: Execute Queries through Files

2002-04-22 Thread Jennifer Moter
do you mean to execute a query that's written in a file? if so, there are two ways: for bournse shell type shells ( including WinNT/2K ) mysql --user=myname --password=mypassword -D dbname -v < file.sql > outfile.log2&>1 for c-shell based shells

Re: Execute Queries through Files

2002-04-22 Thread Chris Johnson
Q1: I am not sure what you mean by executing queries through files. Do you mean being able to run a query from a script like this? #!/bin/sh mysql -t -p password -u usename databasename << EOF Select * From mytable; EOF Q2: There are mailing list archives available at http://lists.mysql.com .