Sql code similar to truncate and insert, but in one step
Budget: $10 – $30 USD
I manually truncate my table every day because lots of data change
and then I proceed to insert the new records
INSERT INTO `exsvert`(`ID`, `conc`, `DAN`, `MX`, `GDL`, `LEON`, `MTY`) VALUES
('2000906','La 2000906 Mx 7 / Gdl 2 / Mty 2 / Leon 1','No tienes, hay 2 en GDL','7','2','1','2'),
('2001104','La 2001104 esta agotada totalmente','La tienes agotada y tambien GDL','agotada','agotada','agotada','agotada'),
....and other similar 4,000 rows
then a few hours later I repeat the same process, truncate and insert, but this process takes a few seconds in which if anyone consulting the info gives errors, that’s why I would like to make it in a single process with no interruption.
and then I proceed to insert the new records
INSERT INTO `exsvert`(`ID`, `conc`, `DAN`, `MX`, `GDL`, `LEON`, `MTY`) VALUES
('2000906','La 2000906 Mx 7 / Gdl 2 / Mty 2 / Leon 1','No tienes, hay 2 en GDL','7','2','1','2'),
('2001104','La 2001104 esta agotada totalmente','La tienes agotada y tambien GDL','agotada','agotada','agotada','agotada'),
....and other similar 4,000 rows
then a few hours later I repeat the same process, truncate and insert, but this process takes a few seconds in which if anyone consulting the info gives errors, that’s why I would like to make it in a single process with no interruption.