Закрыт

Sql code similar to truncate and insert, but in one step

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.

Навыки: SQL, MySQL, Управление базами данных, phpMyAdmin

Показать больше: insert xml mssql table count, insert xml file table, student registration system sql code, sql code extract xls file, sql code bid, institute management system vbnet sql code free, sql insert xml elements table, net insert xml content table, sql code display whole number, vbnet insert xml file table, sql insert file content table, extract sql code ssis packages, import export sql code vb6, write sql code will save appointment table, insert google adsense table html code, save step manually inputting stock market data, following sql statements will insert row promotion table, how to read data from xml string and insert into table in sql server, mat table refresh on data change, how to read data from xml file and insert into table in sql server

О работодателе:
( 1 отзыв ) Mexico City, Mexico

ID проекта: #32190302

21 фрилансеров(-а) готовы выполнить эту работу в среднем за $27

(19 отзывов(-а))
5.6
alexvinnik

Hi there, i cn give you an great ideaabut that! Contact me pls. Alex

$15 USD за 1 день
(43 отзывов(-а))
5.3
ahmedbilal2506

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 y Больше

$10 USD за 1 день
(36 отзывов(-а))
5.1
goodwork20k

Hello, I am a php, mysql expert and i can help you to automate this step based on your requirement Please ping me for further discussion thank

$30 USD за 1 день
(7 отзывов(-а))
4.1
Parveenlamba77

Hi There, I am database expert I can automate your above sql process using python. feel free to contact me.

$25 USD за 1 день
(9 отзывов(-а))
3.9
dmkondratovgit

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 Больше

$30 USD за 1 день
(2 отзывов(-а))
3.0
mismailcs

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

$25 USD за 1 день
(4 отзывов(-а))
2.5
harfarooqi

Hi I have seen your job description and interested in sql truncate/insert in single query work. Please provide more details about it Best

$25 USD за 7 дней(-я)
(2 отзывов(-а))
1.2
iralukianova92

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 on Больше

$20 USD за 1 день
(1 отзыв)
1.4
TFComplex

Hi, Greetings from Zuhair Muhammad. I'm interested in doing your work so finally would like to start work now. ' I'm ready for an interview and feel free if you have any queries and contact me anytime 24*7 will be avai Больше

$100 USD за 1 день
(2 отзывов(-а))
1.0
RomanMatveev1

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

$25 USD за 7 дней(-я)
(1 отзыв)
0.6
tenworxusa

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 Больше

$15 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
denorzahar

Hello. If your project is urgent, I can fix your issue within an hour. Please contact me. Thanks.

$50 USD за 1 день
(0 отзывов(-а))
0.0
Work12345x

Hi, I am a very talented software programmer with 13+ years of development experience (5+ years professional work experience). I am a results-oriented professional and possess experience using cutting-edge development Больше

$10 USD за 1 день
(1 отзыв)
0.0
MSSoftdeveloper

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.

$15 USD за 1 день
(0 отзывов(-а))
0.0
Waseemakhan4

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

$16 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
Sidraj20

I have worked on similar projects , have good experience on working on oracle tables and their DDL and DML operation

$25 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
Umeshpatil9444

Hi I'm Umesh patil I'm perfectly handle SQL queries I write the code in minimum price as compipr to other's

$11 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
abhishankdubey

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 Freela Больше

$12 USD за 1 день
(0 отзывов(-а))
0.0
Smitbosamiya

Hello, I am Certified DBA, I Have Solution of This, Just Contact me Then I Will Show You Example & Explain.

$20 USD за 2 дней(-я)
(0 отзывов(-а))
0.0