Delete from multiple tables

Expand Post »

Hi,
How can I delete from multiple tables?
I'm using this query and its not working:
"DELETE FROM table1,table2 WHERE
$localTime > table1.Time OR $localTime > table2.Time";

What I hope to achieve is deleting rows from table1 and table2 where
their Time Field is less than $localTime.

Thanks very much.

Similar Threads

updating 2 HTML tables on one PHP page in PHP
Query multiple tables with duplicate data in MySQL
Searching for a record in multiple tables in VB.NET
Updating multiple tables in C# in C#
Multiple Tables in a Database in Visual Basic 4 / 5 / 6

qazs

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Oct 2004

Permalink

Jun 9th, 2005

Re: Delete from multiple tables

"DELETE FROM table1 WHERE $localTime > Time; DELETE FROM table2 WHERE $localTime > Time";

Troy

Reputation Points: 36

Solved Threads: 6

Posting Whiz

Offline

354 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Dadabik?

Next Thread in MySQL Forum Timeline: i need a simple query to meet my requirement

DaniWeb Message

Cancel Changes

User Name
Password