Trying to create a mysql stored procedure, what is wrong with my syntax?
-
Hello, here is my attempt to create a stored procedure for mysql. USE myDb; CREATE procedure insertSupplier(IN name VARCHAR(255), IN description TEXT, IN categories VARCHAR(255), IN ...show more
-
Answer:
For starters, you're not using the correct syntax for creating a procedure. You need to change the delimiter since you will need to use semi-colon's within your procedure.
JUZ5HXJQ3LBCMQAXYXJ52FWT2U at Yahoo! Answers Visit the source
Other answers
Did you change the delimiter before and after your procedure declaration? e.g. DELIMITER // CREATE PROCEDURE ... BEGIN ... END // DELIMITER ; If you didn't do that, MySQL attempts to interpret each statement in the procedure individually.
Ray
Related Q & A:
- How to create a Restful web service in .Net Using MySQL?Best solution by stackoverflow.com
- What is Hash Table, how to create a hash table?Best solution by Stack Overflow
- how to create a new syntax in java?Best solution by Stack Overflow
- How to create a table in PHP with MySQL?Best solution by Stack Overflow
- What is better, blu-ray/HD-DVD, or a movie stored in digital format like on an ipod?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.