Important MySQL discoveries

Important MySQL discoveries

 

Please first view my table structure:

 

 

Run the following statements:

Update sin_categories set name = 'specificity 1 ', posttime = '000000', lock = '1' where id = '1' Error

 

Update sin_categories set name = 'specificity 1 ', posttime = '000000' where id = '1'

Correct

 

Update 'sin _ categorie 'set' posttime' = '20160301', 'lock' = '1', 'order' = '20160301' where 'sin _ categorie '. 'id' = 1

Correct

 

Here is one of my small discoveries. MySQL must use the 'symbol to escape database fields if the list in the set is greater than two items when you execute an update statement request., in this way, the execution is successful.