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 lagi: modify mysql dump, mysqldump bulk, mysqldump format, swansea, sw851314, mysqldump mssql bulk insert, mysqldump bulk insert, edit mysqldump, mysql dump sql server 2008, 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, modify sql file mysql dump sql server 2005

Tentang Majikan:
( 14 ulasan ) Derry, United Kingdom

ID Projek: #370786

Dianugerahkan kepada:


can help you. tnx.

$30 USD dalam 0 hari
(6 Ulasan)

6 pekerja bebas membida secara purata $68 untuk pekerjaan ini


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)

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)

i can do that , more details,thanks.

$35 USD dalam sehari
(11 Ulasan)

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)

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)

"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)