Hi to all,

I want to ask if MySQL version 5.0 or later supports variable constants?
Like in any programmling languages like Visual Basic 6, you can declare a constant variable and refer to it through the lifetime of your program?
It also won't allow its value to be modified.

Does mySQL have that feature? or we just have to declare a variable and put a default value to it?

thanks and god bless all!

has had that feature since version 3.23

http://dev.mysql.com/doc/refman/4.1/...variables.html

Ok, but still the variable can be modifie. I am asking technically if there are variables similar to that of VB6, which , cannot be modified

this begs the question, why aren't you actually using vb6 if that's what you want?

Don't get me wrong, but I am only asking for that kind of feature in mySQL.

I hate to think what would happen if you filled up the cache of MySQL with constants... Why do you need a constant in MySQL, that is the real question? I see no need for such a thing, and I don't believe any other DBs are utilising this. Why don't you just use a table of constants

very well said