I've distilled the problem I'm having with DELETE/INSERT to an even
simpler test case.
Here's the SQL - it can be used with any database, not just the special
"expdb" I created. I run this script followed by running "mysqlcheck
expdb".
#
USE expdb;
DROP
I'm having a strange problem with trying to delete records with MySQL.
System: Win XP home, Mysql 4.0.15. Implementation with this version
since 10/01/2003 with no problems.
Normal access: MySQL JDBC driver (used to be the MM driver, now obtained
from MySQL), Java SDK 1.4.2_01. Problem has been
Wednesday, November 05, 2003, 1:46:13 PM, Bamelis Steve wrote:
BS> Hi Victoria,
BS> I just found a manual for my version.
BS> Seems that 'USING' doesn't exist in this version.
BS> But I really need to be able to delete rows from my source table with
BS> specific criteria from my destination table
"Bamelis Steve" <[EMAIL PROTECTED]> wrote:
>
> I'm a newbie when it comes to mySQL.
>
> I have the following command.
>
> DELETE FROM tblTest2
>
> USING tblTest2,tblTest
>
> WHERE tblTest.Name = tblTest2.Name
>
> AND tblTest.URL = tblTest2.URL
>
> AND tblTest.Comment = tblTest2.Comment
>
Bamelis,
The error message doesn't seem to match your SQL...
It only shows up to 'AND tblTest.URL = tblT'
but your SQL is 'AND tblTest.Comment = tblTest2.Comment'
Is that a problem??
An example from MySQL manual is 'DELETE FROM t1,t2 USING t1,t2,t3 WHERE
t1.id=t2.id AND t2.id=t3.id'
Leo
Hi,
I'm a newbie when it comes to mySQL.
I have the following command.
DELETE FROM tblTest2
USING tblTest2,tblTest
WHERE tblTest.Name = tblTest2.Name
AND tblTest.URL = tblTest2.URL
AND tblTest.Comment = tblTest2.Comment
I get the following error:
You have an error in your SQL sy
We have a table in the database holding session data. The data is updated
rather oftenly using REPLACE INTO query with primary key. Table structure
is:
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---
