Breaking News: Grepper is joining You.com. Read the official announcement!

READS SQL DATA DETERMINISTIC

Ayoni02 answered on July 23, 2023 Popularity 3/10 Helpfulness 8/10

answer READS SQL DATA DETERMINISTIC

READS SQL DATA DETERMINISTIC

Comment

DETERMINISTIC A routine is considered “deterministic” if it always produces
the same result for the same input parameters and NOT DETERMINISTIC otherwise.
This is mostly used with string or math processing, but not limited to that.

READS SQL DATA This explicitly tells to MySQL that the function will ONLY 
read data from databases, thus, it does not contain instructions that 
modify data, but it contains SQL instructions that read data (e.q. SELECT)

https://stackoverflow.com/questions/26015160/deterministic-no-sql-or-reads-sql-data-in-its-declaration-and-binary-logging-i

Popularity 3/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: deterministic sql

Link to this answer
Share Copy Link