[jtolsdorf]

According to the mysql website:

Quote:

When you use the –safe-updates option, mysql issues the following statement when it connects to the MySQL server:

SET SQL_SAFE_UPDATES=1,SQL_SELECT_LIMIT=1000, SQL_MAX_JOIN_SIZE=1000000

http://dev.mysql.com/doc/mysql/en/safe-updates.html

So it is up to the client to recognize this option and issue the statement above to the mysql server. After that, the mysql server enforces the options set for your connection.

During normal use of SQLyog I would fully expect to be able to select more than 1000 rows. However the safe-updates options is supposed to prevent this (1000 rows max by default and no updates without a where clause containing a key constraint or limit), I was only using it as an example of the safe-updates options not being set.

[Author]

Posts