Which MySQL functions are available

Avatar
  • Answered
I have several MySQL databases up and running and I wish to use some of the built-in functions. I find that some functions are working but some are not. For example I can use ABS(number) but INSERT(string,position,length,new) reports:
"Call to undefined function INSERT()"
Avatar
johnpaulb-imhs1

Hello SETINe5,

Thank you for your question. First, make sure when you added the user to the Database, you granted permission to INSERT:

The MySQL functions are available based on the version your server is running, you can view the MySQL version in cPanel.

Also, here is a helpful link to the Official MySQL reference manual, it provides more specific information on functions.

If you have any further questions, feel free to post them below.

Thank you,

-John-Paul