Which MySQL functions are available

Avatar
SETINe5
  • 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()"
Replies 1
Avatar
0
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