MySQL Forums
Forum List  »  French

Re: Licence plate
Posted by: Jean Molliné
Date: March 28, 2017 02:32AM

Hi,
this forum is in french, so please, use the right forum or write in french to ask questions here.

But i can give you some tips : You must create a stored procedure to do what you want. This procedure must get the laste plate number, then split this number in 3 parts, then increment the central number, if needed, reset the number to 0000 and increment the third part. At least concat the result to get the next plate number et return it.

______________________________________________________________
Une question bien formulée, c'est un problème bien compris : ça représente déjà les 3/4 de la réponse ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
1627
March 28, 2017 02:20AM
Re: Licence plate
838
March 28, 2017 02:32AM


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.