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'');

Habilidades: Processamento de Dados, Processamento de dados

Veja mais: 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

Acerca do Empregador:
( 14 comentários ) Derry, United Kingdom

ID do Projeto: #370786

Concedido a:


can help you. tnx.

$30 USD em 0 dias
(6 Comentários)

6 freelancers estão ofertando em média $68 para esse trabalho


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 in 5 dias
(48 Comentários)

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 in 0 dias
(1 Comentário)

i can do that , more details,thanks.

$35 USD em 1 dia
(11 Comentários)

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 Mais

$60 USD in 0 dias
(1 Comentário)

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

$50 USD in 0 dias
(0 Comentários)

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

$30 USD in 3 dias
(0 Comentários)