Skip to content
Advertisement

MySQL said 1064 You have an error in your SQL syntax

I wrote a MYSQL Procedure for my user registration page, I have already written the PHP part to send data from there to MySQL, and it works fine (tried with a dummy data and retrieval). But there is some sort of problem with my handler or transaction I guess

This is my Procedure:

I always get the error

Is there something obvious I am missing? I have been trying for some time to solve this with almost all the results to show the same error.

Any help will be highly appreciated.

Advertisement

Answer

Ok, I edited my own code and got the required result.

The changes I made was:

If anyone get any other answer, still appreciate it.

Anyways, the above code is now working fine.

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement