mysql solaris binaries

2002-10-03 Thread Stanley, Jason
hi, i've downloaded and unpacked both the 3.2.3 and 4.0.4 binaries for solaris. neither create a var directory, so i create the var directory myself and give mysql ownership of it. yet when i run mysqld it still won't write the pid file. what gives? tia, j

RE: MySQL as a desktop DB

2002-09-25 Thread Stanley, Jason
also: - mysqlstudio - http://www.mysqlstudio.com mascon - http://www.scibit.com -j -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: September 25, 2002 1:09 PM To: Insanely Great; MySQL List Subject: RE: MySQL as a desktop DB I use MySQL as a desktop db.

String Functions and Date Format Living Together in Harmony?

2002-09-20 Thread Stanley, Jason
hello all, i have the following selection in my query... DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME now, i want to apply LCASE or LOWER to it, but i'm a little unsure how to handle the syntax with two sets of parentheses. any insight? tia, j

count query across two tables

2002-07-18 Thread Stanley, Jason
hello all, i'm new to the list (and to mysql, for that matter) and am looking for some help with what should be a fairly simple query. what i'm doing is writing a very simple bulletin board with jsp using two tables in mysql. the first table contains the title and body of the topic and the