如何在其余列中插入随机值

Question

我有这张表，正在处理另一个表中的数据，我需要将其余的数据以 0-10 间隔随机插入，

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%' ;

这是我用于自动填充另一个表中的值的插入代码。

Answer 1

您正在执行以下查询

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%' ;