Which MySQL functions are available
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()"
"Call to undefined function INSERT()"
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