InMotion Hosting Support Center

Which MySQL functions are available

Category: Server Usage

SETINe5
Asked:
2013-07-15 9:37 pm EST

Hits: 719
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.

OTHER ANSWERS

0

John-Paul
Staff
29,997 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,

-John-Paul

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.

Social Media Login

   
Social Login Joomla

Need more Help?

Search

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: support@InMotionHosting.com
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!