Sedang Disiapkan

Modify an mySQL dump

We have an SQL dump of approx 50000 entries and I need someone to edit the entries to remove the bulk of information.

If you know how to work between mySQL dump and Excel and back again for example you will get this done in seconds.

Sample of the dump below:

INSERT INTO `tc_towns` VALUES(44719, 22, 'Zone Point', 'Zone Point - Cornwall [url removed, login to view] [url removed, login to view] SW851314');

INSERT INTO `tc_towns` VALUES(44720, 56, 'Zouch', 'Zouch - Leicestershire [url removed, login to view] [url removed, login to view] SK5023');

INSERT INTO `tc_towns` VALUES(44721, 108, 'Ystradgynlais', '');

INSERT INTO `tc_towns` VALUES(44722, 108, 'Swansea', '');

INSERT INTO `tc_towns` VALUES(44723, 9, 'Cholsey', '');

INSERT INTO `tc_towns` VALUES(44724, 129, 'Abbey', 'galway');

Format required:

INSERT INTO `tc_towns` VALUES(44719, 'Zone Point');

INSERT INTO `tc_towns` VALUES(44720, 'Zouch');

INSERT INTO `tc_towns` VALUES(44721, 'Ystradgynlais');

INSERT INTO `tc_towns` VALUES(44722, 'Swansea');

INSERT INTO `tc_towns` VALUES(44723, 'Cholsey');

INSERT INTO `tc_towns` VALUES(44724, 'Abbey'');

Kemahiran: Pemasukan Data, Pemprosesan Data

Lihat lebih lanjut: modify mysql dump, mysqldump bulk, mysqldump format, swansea, sw851314, mysqldump mssql bulk insert, mysqldump bulk insert, edit mysqldump, mysqldump excel asp, mysql modify values, asp mysql dump, remove insert mysqldump, dump mysql samplle, edit mysql dump, edit mysql dumps, mysql insert sql dump, dump mysql sample, mysql dump insert mssql, mysqldump values, mysql dump bulk, bulk mysqldump, mysql dump excel 2009, mysqldump sql server 2008, dump insert, modify mysql example

Tentang Majikan:
( 14 ulasan ) Derry, United Kingdom

ID Projek: #370786

Dianugerahkan kepada:

CoVaLiDiTy

can help you. tnx.

$30 USD dalam 0 hari
(6 Ulasan)
4.0

6 pekerja bebas membida secara purata $68 untuk pekerjaan ini

spawar

Hi, I've a very good experience in SQL and excel, I'll do this work with a good quality. I'm interested to work with you long term and ready to start it immediately.

$200 USD dalam 5 hari
(48 Ulasan)
5.8
amyodov

This task really doesn't worth more than it... Less than 30 minutes to implement the script, and several hours for potential communication issues.

$30 USD dalam 0 hari
(1 Ulasan)
5.2
eelance

i can do that , more details,thanks.

$35 USD dalam sehari
(11 Ulasan)
4.4
ckyeu

Hello, I am very interested in this task. I am an expert systems administrator and I have tools to carry out desired tasks. I am ready to start immediately. This is a simple task and will only take a few minutes. Th Lagi

$60 USD dalam 0 hari
(1 Ulasan)
3.2
goodtimesalways

Send me the dump and I ll extract in the exact format you want. Have a great day

$50 USD dalam 0 hari
(0 Ulasan)
0.0
belenlicari

"Hello, i am a system engineer with lot of experience on web development, and my speciality are the database models. I have extensive knowledge of database, SQL Server 2000, SQL Server 2005, SQL Server 2008, Access, Or Lagi

$30 USD dalam 3 hari
(0 Ulasan)
0.0