Hello.
Start points for you problem:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
socket=/home.dbdata/mysql/mysql.sock
What is your client thinks about the location of mysqld socket?
Put the same
Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT
This doesn't nesessarily mean that mysql hasn't started. This script waits
only for certain time to check if mysql has started or not. If it is not
started in that time, it simply says 'mysql start failed'. But mysql may
From: John Croson [mailto:[EMAIL PROTECTED]
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
AND month=MONTH(CURDATE())
AND day=DAYOFMONTH(CURDATE())
AND cat_id='2' OR cat_id='5'
AND
Hi John,
I think you missed on the precedence of AND/OR
if you change to
AND (cat_id='2' OR cat_id='5' )
it should work as you want it to
/Johan
John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE
Mike Johnson wrote:
From: John Croson [mailto:[EMAIL PROTECTED]
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
AND month=MONTH(CURDATE())
AND day=DAYOFMONTH(CURDATE())
AND cat_id='2' OR
At 09:35 AM 2/4/2004, John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
AND month=MONTH(CURDATE())
AND day=DAYOFMONTH(CURDATE())
AND cat_id='2' OR cat_id='5'
AND approved='1'
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 04 February 2004 16:03, mos wrote:
At 09:35 AM 2/4/2004, John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
is a crosstab is what you want?
pls. give the result (output of the query) that you expect from the example
and what you are actually getting.
regds,
-Original Message-
From: Charles Kline [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 15, 2003 20:53
To: [EMAIL PROTECTED]
Subject:
Charles-
So, you have a table unique with respect to people (a person appears at
most once), and a table with interests (some number of interests are
associated a person in the first table. This is a one-to-many
relationship. You need to join on the person in the first table.
Something like
Jeff,
Thanks. This is ALMOST doing what I need.
Suppose that the person could have from 0 - 5 records in
tbl_peoples_interests and I need to have each one of those interests as
a different name so I can use it in my PHP form?
Thanks,
Charles
On Saturday, March 15, 2003, at 11:30 AM, Jeff
Charles-
OK, let's say a person has `n' interest id entries in
tbl_people_interests. It seems like you're wanting a result set with
one row per person and (n + 2) (assuming you're selecting first and
last name with the interests). I'm no UEbergeek with respect to SQL,
but I don't think there's
On Thu, Sep 12, 2002 at 11:46:40AM -0700, Kip Krueger wrote:
I need to query a mysql db in the following fashion ...
find me all records whose column 'n' have the letters 'XY' as the first two
characters. where column 'n' is just a short string
to clarify ...
if column 'n' has the
At 10.08 21/11/01 -0700, Steve Meyers wrote:
Wait for 4.1, it will have multi-table updates in it. Until then,
you'll have to use two separate queries.
Steve
i'm also new to mysql but i think you can use MERGE tables.
Couldn't you ?
==
dott.
I've now had an extended dig around this mailing list's archive, and it I
conclude mySql can not perform this type of update directly. Instead I
should create a temp table, select into the temp table and then use that to
do a REPLACE INTO command.
Can someone confirm my conclusion is correct?
Wait for 4.1, it will have multi-table updates in it. Until then,
you'll have to use two separate queries.
Steve
On Wed, 2001-11-21 at 07:28, Charles Allen wrote:
Hi,
A v. basic question from a mySql newbie:
I want to update a table based on the contents of another table. The SQL I
am
15 matches
Mail list logo