First page Back Continue Last page Image

MySQL FUNCTION Characteristic Options

DETERMINISTIC

This means the result is predictable in advance

like data from a field in a table

NOT DETERMINISTIC (Default)

The data is not predictable in advance like a function that uses the NOW() or RAND() functions

READS SQL DATA

Function contains a SELECT statement

MODIFIES SQL DATA

Function contains INPUT, UPDATE or DELETE statements

CONTAINS SQL (Default)

Function contains SQL statements (Like SET) that do not

Read from or Write to the database

NO SQL

This function does not contain any SQL Statements