MySQL5.5 delete table connection syntax change

MySQL5.5 standardizes the writing of SQL statement table connections.

 
 

  
  
delete user a,user2 b from user a join user2 b on a.id=b.id; 
 
 

This code can be written in MySQL5.1 and executed normally, but an error is reported in MySQL5.5. The following is a test:

650) this. width = 650; "border =" 0 "src =" http://www.bkjia.com/uploads/allimg/131229/19222K112-0.png "alt =" "/> 650) this. width = 650; "border =" 0 "src =" http://www.bkjia.com/uploads/allimg/131229/19222GM6-1.png "alt =" "/>

As you can see, an error is reported during execution. The following code is used:

 
 

  
  
delete a,b from user a join user2 b on a.id=b.id; 
 
 
650) this.width=650;" border="0" src="http://www.bkjia.com/uploads/allimg/131229/19222JT4-2.png" alt="" />

Reference manual:

650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131229/19222M414-3.jpg "/>

 

This article is from the "hechun's technical column" blog, please be sure to keep this source http://hcymysql.blog.51cto.com/5223301/1009331