MySQL Forums
Forum List  »  Stored Procedures

Re: Procedure not working
Posted by: Peter Brawley
Date: December 25, 2019 07:02PM

The sproc name indicates it's a transaction. It's not.

You say the requirement is to insert only if the table has no records. The code does the exact opposite.

The quotes round 'wp_codis_postals' don't match.

...(43895, 'Ampolla, l\'')... seems to make no sense, and raises an error; what are you trying to accomplish with the escaped quote?

I've no idea whether any of these errors is the one you allude to in your post because you've not posted the error message.

Options: ReplyQuote


Subject
Views
Written By
Posted
1025
December 25, 2019 06:44PM
Re: Procedure not working
392
December 25, 2019 07:02PM
358
December 26, 2019 05:05PM
335
December 26, 2019 06:53PM
374
December 27, 2019 01:59AM
331
December 27, 2019 10:13AM
324
December 29, 2019 04:20AM
404
December 29, 2019 12:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.