I have created a function in mysql but when I call it using: SELECT myFunction(3);

it says it does not exist. I checked my server and it is in there. I have also tried this also:

INSERT INTO myTable(num, num2) VALUES (15, (SELECT myFunction(15))); 

Is this right and how do I tell mysql the file does exist

Recommended Answers

All 2 Replies

Do you have EXECUTE priviliges?

I think you nred to remove SELECT in thr second query.

Does CALL work?

the syntax for insert/select is usually

INSERT INTO myTable(num, num2) select 15, myFunction(15); 
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.