Re: Date Functions in MySQL

2005-02-23 Thread Clarence
Shoot me now, please. Thanks - I don't know how I missed that! Thanks - re-ran the query and things seem to be a-ok! On Wed, 23 Feb 2005 18:42:17 +0100, Roger Baklund <[EMAIL PROTECTED]> wrote: > Clarence wrote: > > I have a log table that records certain transaction

Date Functions in MySQL

2005-02-23 Thread Clarence
I have a log table that records certain transactions on one of my sites. I'm using a timestamp field to mark the date/time of each transaction. I'm trying to run a query that will display the transactions by date using the following SQL: SELECT COUNT(log_id) AS total, WEEK(FROM_UNIXTIME(UNIX_TIM

MySQL 3.23.49 and HP-UX 10.20 Install

2002-04-08 Thread Clarence W. Robison
=/usr/local/mysql '--with- comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --with-pthread --with-named-thread-libs=-ldce --with-lib-ccflags=-fpic --disable-shared-- Clarence W. Robison, P.E. [EMAIL PROTECTED] ---

(Solved) Help with MATCH ... AGAINST

2001-04-10 Thread Clarence
ork. Anyway, I've RTFM manual and it's unclear about how you implement the syntax. Any help, guidance, etc. would be greatly appreciated. Thanks. -- Clarence -> [EMAIL PROTECTED] - Before posting, please check:

Help with MATCH ... AGAINST

2001-04-10 Thread Clarence
;) AS relevant_num FROM people; Which obviously didn't work. Anyway, I've RTFM manual and it's unclear about how you implement the syntax. Any help, guidance, etc. would be greatly appreciated. Thanks. -- Clarence -> [EMAIL PROTECTED] -

[OT] Rel DB Question

2001-02-21 Thread Clarence Kwei
there anything wrong with have a relationship based on two keys and a char field. Any insights would be greatly appreciated. Thanks very much. -- Clarence Kwei [EMAIL PROTECTED] ScienCentral, Inc. (212) 244-9577 ext. 118 <http://www.stn2.com> <http://www.sciencentral.com> --

Update Question

2001-01-18 Thread Clarence Kwei
greatly appreciated. Thanks. -- Clarence Kwei [EMAIL PROTECTED] ScienCentral, Inc. (212) 244-9577 ext. 118 <http://www.stn2.com> <http://www.sciencentral.com> - Before posting, please check: http://w