Power, sqrt functions

Hi

How to implement unstandard functions as f.e. power, sqrt etx in HeidiSQL, and just add any library.

Any ideas?

Not sure why you call them "unstandard", as MySQL understands these:

SELECT SQRT(12), POW(12,3);

I forgot to mention that three is no such functions in sqlite

SQLite has these two functions as well, try it out.

I tried these functions before I asked.

I have a warning There's no such function for all of these cases.

Maybe it's a reason I am using a portable version. If so, what could be a good and simple solution?

Could be you have an older sqlite3.dll than me.

Mine is the one from the latest builds:

You can update that dll from the repository. Rename to sqlite3.dll and overwrite the existing one in your HeidiSQL/portable folder.

alles ist gut :)

I just only used 64 version. Thx a lot, it makes me more functionality. I will try to find out what are new functions to use :)

Have a nice day