Sql code similar to truncate and insert, but in one step
$10-30 USD
Đã đóng
Đã đăng vào hơn 2 năm trước
$10-30 USD
Thanh toán khi bàn giao
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.
Hi sir
I am interested to work with you.
I can provide you with professional web design services.
I can design for you according to your requirements. I will give you unlimited revision until you will not satisfy for your design.I will deliver this according to your time frame after your award.
I can assure you several things.
* I have expertise in Twitter Bootstrap, Angularjs, HTML5/CSS3, Php, java se,j2ee....
* I have a great web development sense.
* Well organized and clean code easy to understand.
* Validate according to w3c standards.
* I can start it immediately.
* Compatible with all modern browsers and mobile devices.
Looking forward to hearing from you soon.
Thanks
Here, Sir.
I'm web developer major in php.
As you know, almost all php framework use MySQL as their database. So I mastered sql database and will let you easy to work. If you give me task, it will be completed in time on high level.
Please work with me. Thanks.
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 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
Hello.
I appreciate your job posting and I'm sure I can your job as you want since I'm a PHP expert.
I have got great reputations with MySQL and SQL using phpMyAdmin.
I can deliver you as fast as I can in less than one hour.
If you're interested in me, contact me asap.
I'm ready to get into your work now.
THx.
Hi!
I just check your project details and ready to work, I am an expert designer and developer. having expertise in MySQL, SQL, Database Administration and phpMyAdmin
Also I provide best satisfaction to my customers in order to fulfill their requirements
kindly Message me to discuss about project:
Best Wishes
Tenworx USA
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
Hello,
I’d really like to work with you on this one if possible!
I do have a couple of questions, but first I’d like to make you an offer and some background so you can check my work out.
However, I am new to Freelancer and looking to get a few clients that I can build upon. I am having 8 years of experience in Azure, SQL, SSIS and ADF in the IT industry. Also i am having better to solution to merge Truncate and Insert in single query.
You’ll get all the expected stuff like a great professional service and a fast turn around, at a bit less, and I get a bit more exposure.
If the above offer sounds like something you would be interested in, I’d love to hear from you.
Regards,
Abhishank
Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it. We have the right skills to work on this assignment. We will complete the work as per requirement.