redirect output to a file?
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 more easily print the output because I don't want all the information that eSKUeL displays on output either (it doesn't make a new page for results so you can see all the available commands as well and I don't want those visible when results are printed). Is there a way to redirect query output to a file? I didn't see anything in the manual that specified how to do this. By the way, when I copy and paste the data from the html table that eSKUeL displays the results in it appears in excel or word such that each piece of data that was within a cell is put onto a different line so everything is vertical when pasted, instead of having a full line for each record. Obviously that isn't useable. THanks Brandon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
date subtraction error
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 I'm using is the following: select (completion_date-order_date) as days_elapsed from received where completion_date != 0; I get the following as a result: 6 81 Obviously there isn't 81 days between June 27th and July 8th. Can anyone tell me why mysql does the calculation this way and if there is a more correct way of doing the subtraction of the dates? Thanks Brandon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug in 3.23.51 for windows ?
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 works fine, in windows it crashes mysqld with an illegal op. BM Any other SHOW command works but the one I really need for a PHP app to BM work. There is no command SHOW STATUS FROM in the MySQL. You can use SHOW TABLE STATUS: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html my mistake, SHOW TABLE STATUS is what I meant. But anyway I found the problem so this is no longer an issue. My db was created with 3.21.x and I believe SHOW TABLE STATUS wasn't developed until 3.23.x so I recreated my db using 3.23.51 and the command worked w/o crashing mysqld. I'm assuming the fact it was created with an older version was the problem; at the very least the new version creating the db solved whatever was wrong. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Permissions are now denied from the mysql client
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 mysqld then try using the mysql client to access the databases. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug in 3.23.51 for windows ?
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 need for a PHP app to work. thanks brandon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBug Test Signal/Illegal Op received with Show table status comand
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 op. I can do a regular SHOW STATUS w/o problems as well as other SHOW statements. I have no idea why this particular one is causing problems. I really need to figure this out as the PHP app I use depends on this command it seems. It seems that trying to use the other binaries included in the mysql package (mysqld-max, mysqld-nt, etc.) all but freeze up when I attempt a SHOW TABLE STATUS command; other commands work fine though. With the other binaries I'm not given the small dialog window that says Test Signal. I'm just given the illegal op window. Can anyone help? Thanks brandon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php