redirect output to a file?

2002-07-14 Thread Brandon McCombs
Hi, WIth the way eSKUeL (a PHP app I found on freshmeat) displays query results in a table, and the way that copying and pasting that data into a xls or doc file appears I'm hoping to be able to run queries manually on the mysql prompt and have the output redirected to a file so that I'm able to

date subtraction error

2002-07-13 Thread Brandon McCombs
Hi, Maybe I'm missing something but I tried solution someone posted for someone else's problem concerning finding out # of days between 2 dates. I have 2 sets of dates I'm working with in my sample DB. order_date completion_date 2002-07-03 2002-07-09 and 2002-06-27 2002-07-08 Now the query

Re: bug in 3.23.51 for windows ?

2002-06-24 Thread Brandon McCombs
Victoria Reznichenko wrote: Brandon, Saturday, June 22, 2002, 9:00:49 PM, you wrote: BM Is there any particular reason that anyone knows of that would prevent BM mysql 3.23.51 for windows from working upon the execution of the SHOW BM STATUS FROM tablename query? BM In Linux it

Re: Permissions are now denied from the mysql client

2002-06-23 Thread Brandon McCombs
Ruben I Safir wrote: I recently installed mysql on a new system and the client on works with root? Whats up? ruben@www2:~ !mys mysql -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ruben@www2:~ mysqld isn't running. Launch

bug in 3.23.51 for windows ?

2002-06-22 Thread Brandon McCombs
Is there any particular reason that anyone knows of that would prevent mysql 3.23.51 for windows from working upon the execution of the SHOW STATUS FROM tablename query? In Linux it works fine, in windows it crashes mysqld with an illegal op. Any other SHOW command works but the one I really

DBug Test Signal/Illegal Op received with Show table status comand

2002-06-21 Thread Brandon McCombs
hello, i'm using mysql 3.23.51-max on windows 98. It worked fine up until the point where I started using a PHP app that used the command SHOW TABLE STATUS FROM tablename. Everytime this is executed Mysql gives me a dialog window that says Test Signal with an OK button, then I get an illegal