Mysql----Join用法(Inner join,Left join,Right join, Cross join, Union模拟Full join)及---性能优化
前期数据准备CREATE TABLE atable(aID int( 1 ) AUTO_INCREMENT PRIMARY KEY ,aNum char( 20 ));CREATE TABLE btable(bID int( 1 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,bName char( 20 ) );INSERT
复制链接