RE: Can anyone help with a search? (Thanks)

Thanks everyone for the help, you are an awesome crowd. We got it :) Alan -Original Message- From: Peter Pentchev [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 10:19 AM To: Alan Halls Cc: [EMAIL PROTECTED] Subject: Re: Can anyone help with a search? On Tue, Apr 24, 2001 at

Can anyone help with a search?

are no dead links, a worthy goal don't you think. We need to do a text-based search that includes sub-directories. Anyone know the command? Alan Halls Adoption.com - Before posting, please check: http://www.mysql.com/manua

RE: Hmmm. Error message...

Hi there, Do a find command...: %find / -name "mysql.sock" Then when you start safe_mysqld do it with the switch : %./safe_mysqld -S /whatever/the/path/mysql.sock And it should work. Alan -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 7:23

Need bid for small job.

have around. Email me with a quote sheet and time frame to completion. Payment upon completion. Alan Halls Adoption.com Webmaster [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the m

Cracking Win 2000 hash?

I have a flat txt file that I need to decrypt so that I can build a new database for membership. It was encrypted on a Windows 2000 box. Here is an example of the format: mystic:kdYE[JQKAZAKaMZEKWNeL: mr:ihIAUNUYBACYUZeK_^]d: jr:bxX[TMcaXAeIed__[LWN: Anybody have any suggestions? Alan -

RE: Random record

You have to have version 3.23 of mysql and then you can add ORDER BY RAND() to the end of your query. Alan -Original Message- From: joe [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2018 4:40 PM To: MySQL Subject: Random record Does anyone have any good ideas on how to pull a r

Is sequencing possible in Mysql?

I read in the O'reilly book about sequencing but it only mentions msql. Can you do the same thing with Mysql? I have a table that has 2 fields. 1 is an auto-incrementing field the other is a profile id that is joined to some other tables to track how often a record was accessed. The way we are do

RE: Two query issues -- need help

Here is what our company uses to do the page division on adoptablekids.com I have used it for a few other applications with minimum changes This code would give you five per page. select * from profile order by id DESC return if ({sys:num_pages} <= 1)

Thanks

Just wanted to say thanks to all the people that help out here. I have seen more problems solved here than anywhere and not just on mysql. It has been so much fun to be on this list and see everyone cooperate to get these problems fixed. Thanks again. Alan Halls Adoption.com Webmaster

Restart server when it hangs?

Hi, I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking up. I go into the "top" program and the mysql process is taking up 95-98% of the processor and continually has to be killed and restarted. We are running on an BSDI4.2 / Apache server using PHP pages, I am not u

It keeps hanging it's self, so I killed it :)

Hi, I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking up. I go into the "top" program and the mysql process is taking up 95-98% of the processor and continually has to be killed and restarted. We are running on an BSDI4.2 / Apache server using PHP pages, I am not u

BSDI 4.2?

Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an error during the make command. Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

FW: Selecting a random record

id (id) -> ); ERROR 1064: You have an error in your SQL syntax near 'when datetime DEFAULT '-00-00 00:00:00' NOT NULL, approved char(3) NOT NU' at line 12 Alan Halls Adoption.com - Before pos

Selecting a random record

s but don't know how to randomize what I display on the page. Can anyone help? I have been working futilly on this project :) Alan Halls Adoption.com - Before posting, please check: http://www.mysql.com/manual