How can I solve the problem of restoring MySQL multi-join table queries? The following describes how to solve the problem of restoring MySQL multi-join table queries. We hope this will help you learn MySQL multi-join table queries.
------------------------------------- Group by solution --------------------------------------
- SELECT dede_addonarticle.aid, dede_addonarticle.typeid,
-
- dede_addonarticle.body,dede_archives.typeid,dede_archives.title
- FROM dede_addonarticle,dede_archives
- WHERE dede_addonarticle.typeid = 29 and dede_addonarticle.typeid = dede_archives.typeid
-
As in the preceding query method, the nth power of the slave node appears.
Bytes -------------------------------------------------------------------------------------------------
- SELECT dede_addonarticle.aid, dede_addonarticle.typeid, dede_addonarticle.body,dede_archives.typeid,dede_archives.title
- FROM dede_addonarticle,dede_archives
- where dede_addonarticle.typeid = 29
- GROUP BY dede_addonarticle.aid
-
Group by can solve the problem of auto-recovery. dede_addonarticle.aid is where the auto-recovery occurs.
Implementation of MySQL multi-Table Deletion
Advantages and disadvantages of MySQL independent tablespace
Case sensitivity of mysql Databases
Restoration of MySQL MyISAM Table Structure
In-depth parsing MySQL Association Table Creation