SELECT multiple table and put them in the same format as the first one

user_13359643 0
Viewed 42

i want to bring out a table made of other table with a specific format which is already defined

i already did this so the empty one are replace by "--":


INSERT INTO 
`saisie_support_general`
(`Categorie`, `Urgence`, `Code_CM`, `Type`, `S_Type`, `Details`, `Date`, `Status`, `Acteurs`, `Semaine`, `Date_fin`, `Resolution`, `Date_Modif`, `Date_Modif_Saisie`, `Matricule_creation`, `Matricule_Modif`)
 SELECT
    `Categorie` as `Categorie`,
    `Urgence` as `Urgence`,
    `Code_CM` as `Code_CM`,
    '--' as `Type`,
    '--' as `S_Type`,
    CONCAT(`EAN`,' ', `SIGMA`,' ',`Libelle`,' ',`Famille_Actuelle`,' ',`Famille_Souhaitee`) as `Details`,
    '--' as `Date`,
    '--' as `Status`,
    '--' as `Acteurs`,
    '--' as `Semaine`,
    '--' as `Date_fin`,
    '--' as `Resolution`,
    '--' as `Date_Modif`, 
    '--' as `Date_Modif_Saisie`,
    '--' as `Matricule_creation`,
    '--' as `Matricule_Modif` 
    FROM `table_x` WHERE 1`

This is one of the 5 sql select I plan to add to the table

I want to keep the "INSERT INTO" but at each call the table was filled with all of what was inside.

Is it possible to make a temporary table ? Or is it possible to only keep the last iteration of the table ? I tried several things but my brain blocked and decided not to work anymore when he think about sql.

Thx.

sql
0 Answers
Related