DanDaBeginner Posted April 11, 2007 Share Posted April 11, 2007 im just wondering if theres a 1 query that will delete in two tables like: -query- "DELETE FROM table1, table2 WHERE id = 3" --------- this query ofcourse will not work, but I dont know in other engines im using myisam...and I know this can be done having a two query but for the wonder that bump my head about 5minutes ago and decided to asked this in this forum... thanx Dan Quote Link to comment Share on other sites More sharing options...
fenway Posted April 11, 2007 Share Posted April 11, 2007 It will work, but you have to tell it what tables to delete from, e.g. DELETE table1, table2 from table1, table2 where id = 3. Quote Link to comment Share on other sites More sharing options...
gluck Posted April 11, 2007 Share Posted April 11, 2007 read the multiple table delete help on mysql Quote Link to comment Share on other sites More sharing options...
DanDaBeginner Posted April 12, 2007 Author Share Posted April 12, 2007 thanks guys... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.