SET a variable in mysql only once -


i using classic asp , mysql (using php wouldn't change point of question).

i need set variable on homepage:

set block_encryption_mode = 'aes-256-cbc' 

i can not set global variable other users using server , may use default block_encryption_mode.

i know can use statement using asp/php on beginning of each webpage, seems using resources; every user execute set statement on every page...

is there way set variable or execute other sql statement @ beggining on each session, onstart event asp has, maybe? or how achieve goal without executing query each user on every page have?

it safe call set on every page executes in orders of microseconds. there literally no overhead calling set on open connection.

unless can apply setting globally, not bother. set block_encryption_mode (together collation , timezone) directly after acquiring database connection handle.


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -