Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Power, sqrt functions

azielnik's profile image azielnik posted 3 months ago in General Permalink

Hi

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

Any ideas?

ansgar's profile image ansgar posted 3 months ago Permalink

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

SELECT SQRT(12), POW(12,3);
azielnik's profile image azielnik posted 3 months ago Permalink

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

ansgar's profile image ansgar posted 3 months ago Permalink

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

azielnik's profile image azielnik posted 3 months ago Permalink

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?

1 attachment(s):
  • Zrzut-ekranu-2021-09-15-093306
ansgar's profile image ansgar posted 3 months ago Permalink

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

Mine is the one from the latest builds: Description

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

azielnik's profile image azielnik posted 3 months ago Permalink

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

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.