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.
21 фрилансеров(-а) готовы выполнить эту работу в среднем за $27
Hi i am software developer with great skills of php,mysql,sql,html,css,jquery,wp, laravel et am available to start your work now and finish your sql works in your limited time
I checked your project and It is simple for me. I can finish it within a few hours. Hope to meet and have a talk about your project in detail. Sincere Regards
Hi, My name is Saqib. I am a software developer. I have read your project details "Sql code similar to truncate and insert, but in one step". I have a solution for you if you hire me then will discuss further. Thanks.
Hi, Greeting from Waseem! I look forward to contributing my skills and experiences to your project. I possess all the skills that you have outlined, and can effectively work towards tight deadlines. Thanks