InMotion Hosting Support Center

Which MySQL functions are available

Category: Server Usage

2013-07-15 9:37 pm EST

Hits: 726
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()"

You must login before you can ask a follow up question.

You must login before you can submit an answer.



31,035 Points
2013-07-16 9:50 am EST
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,


You must login before you can post a comment about this answer.

Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!