What does this cursor/pointer syntax mean in SQL?

Asked

Viewed 43 times

-2

What does this SQL cursor/pointer syntax mean?

SET @OLD_SQL_MODE = @@SQL_MODE,
SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,
          ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
mysql sql cursor

1 answer

1

SQL_MODE serves to define how SQL commands will be treated.

For example, NO_ZERO_IN_DATE controls whether it will accept a date with month 0, and NO_ZERO_DATE defines whether it will accept a date with zeros. If they are enabled, when trying to enter it will record but will give a Warning (warning). If STRICT_MODE is enabled, it will not record.

Here is a full list of available options:

https://dev.mysql.com/doc/refman/5.6/en/sql-mode.html

Browser other questions tagged mysql sql cursor

You are not signed in. Login or sign up in order to post.