How do I set mysqld hears only on eth0? i am using FC
linux.
-- God Bless Us --
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives:
not works. it's still show same result. any idea?
- Original Message -
From: Quentin Bennett
[EMAIL PROTECTED]
To: The Nice Spider [EMAIL PROTECTED];
mysql@lists.mysql.com
Sent: Thursday, August 10, 2006 12:43 PM
Subject: RE: Group by base on latest time field,
possible?
Try
select
I want the group by result take the latest field, but
my query result look
like get the random row.
Here I described:
Thread SubjectTime
-
5 Re:test 33 1155203794
5 test 33 1155203772
8 test
I believe the answer is that there isn't a way to
fix the syntax for 3.23,
because 3.23 simply doesn't support multi-table
deletes. An alternative
solution is needed.
One option would be to do this programmatically.
Collect the sectionids
with a SELECT, then delete them with a separate
This query running fine on 4.0.25 but when trying
on
3.23 an error occurs.
can one help me to find correct command for 3.23?
Probably if you post the error message you get.
DELETE FROM A
USING A
RIGHT JOIN B ON B.id = A.sectionid
WHERE B.id is null
error message on 3.23 is:
You have an
Hi,
This query running fine on 4.0.25 but when trying on
3.23 an error occurs.
can one help me to find correct command for 3.23?
DELETE FROM A
USING A
RIGHT JOIN B ON B.id = A.sectionid
WHERE B.id is null
This task is deleted any row in A that have no items
on B.
If I have table like:
CODE QTY
100 30
200 20
300 25
and I want a result like:
CODE QTY SUBTOTAL
100 30 30
200 20 50 (this come from 30+20)
300 25 75 (this come from 50+25)
How to write query like that?
Using Delphi to with this query: SELECT TOTAL :=
PRICE * QTY FROM
INV_PRODUCT
will caused error Parameter object is improperly
defined. Inconsistent or
incomplete information was provided. because Delphi
look it as Parameter (a
parameter of query in Delphi using : at the
beginning).
Is it
Does MySQL support:
SELECT ID_TAG= ID
FROM TABLE
rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty.
-
Yahoo! FareChase - Search multiple travel sites in one click.
On Nov 7, 2005, at 11:04 AM, Scott Noyes wrote:
delete from x where ID not in (select ID from x
order by timestamp desc
limit
100);
It's a good suggestion, I'm just shying away from it
because it seems
more resource intensive than using an offset, and my
ISP is super anal
about
10 matches
Mail list logo
