Shulou(Shulou.com)05/31 Report--

This article mainly explains "join statement algorithm and optimization method in MySQL", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let Xiaobian take you to learn "join statement algorithm and optimization method in MySQL"!

I. Join statement algorithm

Create two tables t1 and t2

CREATE TABLE `t2` ( `id` int(11) NOT NULL, `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `a` (`a`)) ENGINE=InnoDB;CREATE DEFINER=`root`@`%` PROCEDURE `idata`()BEGIN declare i int; set i=1; while(i

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.