Member Avatar for Transcendent

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

  • 3 Contributors
  • 2 Replies
  • 209 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by jstfsklh211
Member Avatar for pritaeas

Do you have EXECUTE priviliges?

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

Does CALL work?

Edited by pritaeas
Member Avatar for jstfsklh211

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.