1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
SET @sqlcmd := CONCAT('insert into calcul_ligne_modifications(code_client,nom_base,nb_ligne,nb_ligne_negatif) values("',client_id);
SET @sqlcmd := CONCAT(@sqlcmd,'","');
SET @sqlcmd := CONCAT(@sqlcmd,base_nom);
SET @sqlcmd := CONCAT (@sqlcmd,'",(select count(id) from');
SET @sqlcmd := CONCAT(@sqlcmd,base_nom);
SET @sqlcmd := CONCAT(@sqlcmd, nomdelatable);
SET @sqlcmd := CONCAT(@sqlcmd ,'),');
SET @sqlcmd := CONCAT(@sqlcmd,'(select count(id) from');
SET @sqlcmd := CONCAT(@sqlcmd, base_nom);
SET @sqlcmd := CONCAT(@sqlcmd,nomdelatable);
SET @sqlcmd := CONCAT(@sqlcmd,'where qui <0))');
PREPARE stmnt FROM @sqlcmd;
EXECUTE stmnt ;
DEALLOCATE PREPARE stmnt; |
Partager