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

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


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions