Usage of visual charts in MySQL and tips for multi-table INNERJOIN _ MySQL

The use of visual charts in MySQL and the multi-table INNERJOIN technique bitsCN.com for multi-table join queries. if the relationship between tables is clear and the structure is simple, creating a view SQL code CREATE VIEW view_name AS SELECT t1.xxx, t2.xxx, t3.xxx FROM (table1 t1 inner join table2 t2 ON t1.fid = t2.fid) inner join table3 t3 ON t1.mid = t3.mid; three table associations are used here, tips for writing multi-table join inner join statements 1. first, write the simplest 2-table join INNER JOIN2. then use () to expand all data FROM after FROM to the end of the statement. JOIN to the inner join of the next table at the end of the statement. remember this principle. in the future, four tables will be joined. five tables will not be difficult to JOIN. deleting the VIEW SQL code DROP VIEW view_name author lj6684bitsCN.com