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.
>> 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
> 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 sepa
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 4
not works. it's still show same result. any idea?
- Original Message -
From: "Quentin Bennett"
<[EMAIL PROTECTED]>
To: "The Nice Spider" <[EMAIL PROTECTED]>;
Sent: Thursday, August 10, 2006 12:43 PM
Subject: RE: Group by base on latest time field
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: http://lists
> 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
>
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.
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
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?
---
10 matches
Mail list logo
