Please support our MySQL advertiser: Programming Forums
Views: 12920 | Replies: 1
 |
•
•
Join Date: Oct 2004
Location: Singapore
Posts: 7
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
