Re: emergency help
> I got the message: > > [root@mothra /tmp]# safe_mysqld & > > [1] 3922 > > [root@mothra /tmp]# Starting mysqld daemon with databases from > /usr/local/var > mysqld daemon ended > Are your databases in there? If you do a ll /usr/local/var Do you see a directory for each database of yours, with the same names? L.A. - 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: emergency help
> Last Saturday when I rebooted Red Hat > Linux, mysql database server didn't come back any more. Try typing this on the command line: safe_mysqld & Then tell us what happens. :-) L.A. - 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: Help! MySQL variables laugh at me
> I have only had a quick look over this and already have a question for the > simple example you've provided. How are you determining the last value > entered before entering the new value? The only way I see you of > effectively accomplishing this is through the use of a datetime column. Or > am I missing something? Wait wait wait! I see what you mean. What I'm seeing as a loop (rows upon rows of data from the database) is a single query to MySQL. So it's fist selecting, then calculating my variable, then sorting. And in sorting, I see "wrong" values for my "is different from the previous" pseudo field. Glact. Is there anything I can do to get the functionality I'm after in any other way? I seem to remember there's a "having" clause which gets computed in the end? L.A. - 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
FW: Help! MySQL variables laugh at me
> I have only had a quick look over this and already have a question for the > simple example you've provided. How are you determining the last value > entered before entering the new value? The only way I see you of > effectively accomplishing this is through the use of a datetime column. Or > am I missing something? I don't understand perfectly your question. Do you mean "how do I keep records in order" or "how do I keep track of the previous record's field value in the SELECTing query"? "how do I keep records in order" In the simple example, I don't. I don't care what order the records come out, it's just an example database. :-) In the complex (real-life) example there is an ORDER BY clause. "how do I keep track of the previous record's field value when SELECTing" I use a variable called @oldOrdine. The last thing I do in the SELECT is stuffing in there the value of the record for the current field. Then, on the subsequent record iteration, I compare its current value with the then-current field value. L.A. -- End of Forwarded Message - 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
Help! MySQL variables laugh at me
1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very Thin | 1 | +--+++--+---++ 13 rows in set (0.09 sec) Looks like a nasty bug to me (by the way, I'm running v3.23.28), but maybe I'm just dumb? And of course the deadline is looming, etc. What can I do? Please note that I will gladly accept a workaround, but everything must be done inside a single MySQL query. (Which will later get processed by a big, nasty PHP program which will do unwholesome things on it and which I can not touch). Thanks in advance. Luca Accomazzi - 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