1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| DELIMITER |
CREATE PROCEDURE insert_clt (
IN id decimal(18,0)
, IN typePers decimal(18,0)
, IN nom varchar(50)
, IN adresse varchar(70)
, IN cPostal varchar(5)
, IN vil varchar(40)
, IN tel varchar(10)
)
BEGIN
IF(id IS NOT NULL)
THEN
UPDATE client
SET
idTypePers = typePers
, nomClient = nom
, adresseClient = adresse
, codePostal = cPostal
, ville = vil
, telClient = tel
WHERE idClient = id;
ELSEIF(nom IS NOT NULL AND tel IS NOT NULL)
THEN
INSERT INTO client (
idTypePers
, nomClient
, adresseClient
, codePostal
, ville
, telClient
)
VALUES (typePers, nom, adresse, cPostal, vil, tel);
END|
DELIMITER; |
Partager