This kind of query should work – after rewriting with explicit JOIN syntax: SELECT something FROM master parent JOIN master child ON child.parent_id = parent.id LEFT JOIN second parentdata ON parentdata.id = parent.secondary_id LEFT JOIN second childdata ON childdata.id = child.secondary_id WHERE parent.parent_id = ‘rootID’; The tripping wire here is that an explicit JOIN binds … Read more
You can’t. However, you CAN use a transaction and have both of them be contained within one transaction. START TRANSACTION; INSERT INTO table1 VALUES (‘1′,’2′,’3’); INSERT INTO table2 VALUES (‘bob’,’smith’); COMMIT; http://dev.mysql.com/doc/refman/5.1/en/commit.html
The simplest solution would be a correlated sub select: select A.* from table_A A where A.id in ( select B.id from table_B B where B.tag = ‘chair’ ) Alternatively you could join the tables and filter the rows you want: select A.* from table_A A inner join table_B B on A.id = B.id where B.tag … Read more
What you do here is called a JOIN (although you do it implicitly because you select from multiple tables). This means, if you didn’t put any conditions in your WHERE clause, you had all combinations of those tables. Only with your condition you restrict your join to those rows where the drink id matches. But … Read more
For joins, I strongly prefer query-syntax for all the details that are happily hidden (not the least of which are the transparent identifiers involved with the intermediate projections along the way that are apparent in the dot-syntax equivalent). However, you asked regarding Lambdas which I think you have everything you need – you just need … Read more
We can use the following syntax to drop multiple tables: DROP TABLE IF EXISTS B,C,A; This can be placed in the beginning of the script instead of individually dropping each table.