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 Link to comment https://forums.phpfreaks.com/topic/46558-solved-is-this-possible/ 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. Link to comment https://forums.phpfreaks.com/topic/46558-solved-is-this-possible/#findComment-226703 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 Link to comment https://forums.phpfreaks.com/topic/46558-solved-is-this-possible/#findComment-226969 Share on other sites More sharing options...
DanDaBeginner Posted April 12, 2007 Author Share Posted April 12, 2007 thanks guys... Link to comment https://forums.phpfreaks.com/topic/46558-solved-is-this-possible/#findComment-227428 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.