MySQL Whitespace removal

We have a SQL table with around 128,000 records in. We have a field called Number_Range which holds details of allocated UK telephone number ranges (See NNG_Example attached). You will see that between the digits in the Number_Range column there is white space and I need this to be removed. I have tried to do this using the MySQL Update command on a small subset of data for the 01329 area code (where the NNG is 01329) using the below SQL query

UPDATE nng SET nng.Number_Range = Replace([`Number_Range`],' ','')

WHERE ((([login to view URL])="01329"));

(which usually works correctly) but it's not doing it. If I run it via MySQL directly as a query or I run it via the MS-Access front-end I get a message which tells me that the query failed due to locking violations on all of the records.

I need someone to access the SQL table and fix it for me.

Compétences : MySQL, SQL

en voir plus : freelance scrape small business data, mysql lost connection fix, mysql marked crash fix, importing yahoo small business data quickbooks, xcart mysql unknown column fix, fix site small, encryption small amount data, small business data collection, small project data, php mysql sql injection fix, need fix yahoo small business wordpress permalinks, small project data database, small task data entry

Concernant l'employeur :
( 1 commentaire ) Tutshill, United Kingdom

Nº du projet : #21389176

Décerné à:


hi sir, i will remove the space from all the numbers right now using php myadmin, will do for 10 gbp, thanks......................................

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% GBP en 1 jour
(55 Commentaires)

10 freelance font une offre moyenne de £22 pour ce travail


Hello I am skilled mysql developer and I am working in web development from last five year so please feel free to contact me for more discussion and Please check my profile for work and experience Thank you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(146 Commentaires)

Hi there, I am an expert at the PHP & can write a custom PHP script to get this done. Available to start right away let me know if you would like me to start. thank you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(29 Commentaires)

Glad to meet you. (✿◠‿◠) :) I have checked your project description and requirements carefully. I am a senior software developer has 8+ years of good experience. I will never make you disappointed. If you give me a ch Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(4 Commentaires)

Hi, i'm available to help you with the SQL Whitespace removal, that doesn't keep more than 5 minutes or 10, contact me if you want it.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(9 Commentaires)

Dear Sir/Madam, Hop you are doing great!. I am MySQL expert and can surely assist you with my service in removing white space right now via ANY DESK as per your requirements. Looking forward for your positive respon Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(3 Commentaires)

Hello Dear, Greetings for the day! ⭐⭐⭐⭐⭐ I CAN START IMMEDIATELY ⭐⭐⭐⭐⭐ My name is Dmitry Kraitor and I am individual full-stack&full-time web developer. I have gone through the project description and I am very int Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(6 Commentaires)

I commit myself to any job, taking full responsibility in completing projects on time. I am hard working,good programmer, fast learner and adaptable to meet my employer's timezone. I commit myself to any job, taking Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(2 Commentaires)

Hello. Your sentences make me so exciting. I am good at , has more than 3 years of development history. I will guarantee the quality and speed of your project. Just call me your friend, give me your hands and we will g Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(3 Commentaires)

I am good in mysql database along with scripting, please let me know if you are good to award this project to me

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(1 Évaluation)