[SOLVED] How can I insert random values in the rest of the columns

Issue

Im haveing this table and is felling with datas from another table and i need the rest to be random inserted form 0-10 interval

CREATE TABLE IF NOT EXISTS `Spital`.`Chirurgie` (
      `ID Persoanl` INT NOT NULL,
      `Doctor` VARCHAR(45) NULL,
      `Ore` VARCHAR(45) NULL,
      `Pacienti tratati` VARCHAR(45) NULL,
      `ID Produse` INT NULL,
      `Denumire` VARCHAR(45) NULL,
      `Cantitate` INT NULL,
      `IdDepartament` INT NULL,
      PRIMARY KEY (`ID Persoanl`),



INSERT INTO `spital`.`chirurgie`
            (`ID Persoanl`,
             `Doctor`,
             `Ore`)
SELECT `ID Angajare`,
       `Asistent/Medic`,
       `Ore lucrate`
FROM   `spital`.`personal` 
where `Specializare` like '%Chirurgie%' and `Asistent/Medic`like '%Medic%' ;

This is the inseration code that im using for auto fill the values from the other table.

Solution

you following query

INSERT INTO `spital`.`chirurgie`
            (`ID Persoanl`,
             `Doctor`,
             `Ore`,
             `Pacienti tratati`,
             `ID Produse`,
             `Cantitate`)
SELECT `ID Angajare`,
       `Asistent/Medic`,
       `Ore lucrate`,
        floor(rand()*10)+1 as `Pacienti tratati`,
        floor(rand()*10)+1 as `ID Produse`,
        floor(rand()*10)+1 as  `Cantitate`
FROM   `spital`.`personal` 
where `Specializare` like '%Chirurgie%' and `Asistent/Medic`like '%Medic%' ;

Answered By – RF1991

Answer Checked By – Senaida (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published.