What are these sql modes in mysql?

5

Here is the code:

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
    
asked by anonymous 27.09.2017 / 18:14

1 answer

0

You are setting flags or settings for the next queries that will be executed. They are usually placed automatically during database export to avoid incompatibility or problems in older versions of MySQL.

    
24.03.2018 / 16:44