1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| set @table=:tbl;
set @nom = :nom;
set @reference = :reference;
set @utilisateur= :Utilisateur;
set @query=
concat('insert into articles', @table,' (');
set @query1 = '`CodeInterne`,`Nom`,`Reference`,`DateCreation`,`UtilisateurCreation`,`DateModif`,`UtilisateurModification`';
set @query2=')values(';
set @query3=
concat('NULL,"'
,@Nom,
'","',
@Reference,
'","',
Now(),
'","',
@Utilisateur,
'",NULL,NULL)');
set @req=concat(@query,@query1,@query2,@query3);
prepare ex from @req;
execute ex;
DEALLOCATE PREPARE Ex; |
Partager