Can anybody guide in
* Selecting certain fields from two or more tables with certain things common
* deleting from two or more tables having common id
thanks in advance..................
Help me on complex queries ???
Moderator: General Moderators
- neel_basu
- Forum Contributor
- Posts: 454
- Joined: Wed Dec 06, 2006 9:33 am
- Location: Picnic Garden, Kolkata, India
If I Understand Your Question I Think mysqli_multi_query() Is your Answer
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
I think PHPycho is referring to JOINs neel_basu.
Typically selecting elements from two or more tables requires a JOIN. Otherwise it's one query per table.
Foreign key constructs can perform deletes across tables, as can simply deleting from each table separately. Some databases support multiple table deletes, but you'll need to look at their manual for that information.
Typically selecting elements from two or more tables requires a JOIN. Otherwise it's one query per table.
Foreign key constructs can perform deletes across tables, as can simply deleting from each table separately. Some databases support multiple table deletes, but you'll need to look at their manual for that information.