Lengkap

run a query in SQL

I have a table called "customers" in a database... i have a field in this table, called "zip_code"

zip_code varchar(255) utf8mb4_unicode_ci

zip code should be always 5 character... like "08001" or "28001" or "42001"

But i have certain cases were the field have been filled with only 4 character.. as "1001", "8901" or "1234"

I dont now how to write the sql sentence for this:

For all the data points in the field "zip_code" of the table "customers" with only 4 characters... add a "0" in the first place...

ie...

if the data is 8001... it should be 08001...

if the data is 1234 it should be 01234

taking care that there might be 28001 and 41234 that sould not be changed because they already have 5 characaters...

so i need the text to Run SQL query on table [login to view URL]:

Kemahiran: SQL, MySQL, Pelayan Microsoft SQL, PHP, SQLite

Lihat lagi: sql query remote database mysql, sql database size query, clone sql database query, sql query sql database size, sql query remote database, sample sql database query form, input form query sql database, write sql query parent child relation tables database, sql database query visual basic, vbscript query sql database csv, word vba sql database query, windows gadget query sql database, write sql query joins tables example database uses, matlab query sql database gui, sql query access database, create a sql database and create a simple but good looking website where i can access and query the database, query form sql database to show in textboxs c#, query form sql database to show in textboxs c, query access database from sql server

Tentang Majikan:
( 47 ulasan ) Sevilla, Spain

ID Projek: #31015260

Dianugerahkan kepada:

AmirKhaled29

i wont talk to much your task is too much simple as much as you can imagine just contact me and i'll do in minutes

€14 EUR dalam sehari
(0 Ulasan)
0.0

27 pekerja bebas membida secara purata €19 untuk pekerjaan ini

(342 Ulasan)
7.9
vladang

Hello sir/madam... I can add 0 in front of ZIP code. Please, contact me to make deal Regards Vladimir

€20 EUR dalam sehari
(137 Ulasan)
6.6
(144 Ulasan)
6.1
xGabryMC

Hi, you could run this to check if the "where condition" is correct: SELECT * FROM [login to view URL] WHERE LENGTH(zip_code) = 4 then to update and pad the string with a leading 0 at the beggining use UPDATE petpla Lagi

€25 EUR dalam sehari
(20 Ulasan)
5.0
(20 Ulasan)
4.6
aodinaev000

Hi there. I am professional full stack web developer. I will be glad to help you. Please check my profile. Thanks.

€30 EUR dalam sehari
(13 Ulasan)
4.3
fugus

Hello, I am an expert in database management and administration. I specialize in MYSQL, ORACLE and Postgress. I can work on your work ASAP. Come over the chat we discuss more. Thank you

€20 EUR dalam sehari
(22 Ulasan)
3.9
livenow267

Hi, Based on your description, I see you are looking for a developer who can start your project immediately. I am a senior web developer with extensive development background. I have more than 5 years of development ex Lagi

€19 EUR dalam 7 hari
(18 Ulasan)
4.1
hoaxuyentri

Hello! I hope you are doing well. I am an experienced database administrator using TSQL in long time (sql server, mysql, oracle, postgres, mariadb). You can refer my profile in link https://www.freelancer.com/u/hoaxuy Lagi

€12 EUR dalam sehari
(15 Ulasan)
3.9
adricabrelles

Hola Soy un DBA de Valencia con más de 20 años de experiencia en Oracle, sql server, mysql , .... consultas sql. Te puedo ayudar con tu consulta. Saludos.

€20 EUR dalam 7 hari
(17 Ulasan)
4.2
anandan1995

I have a experience in asp.net, MVC, web API,Laravel,Php,,Java, Spring mvc,Hibernate, c#, SQL, entity framework,linq, razor view (Cshtl), html, Wordpress,Joomla,Shopify,Jstl,bootstrap,Angular JS, Jquery, Json,XML, repo Lagi

€29 EUR dalam sehari
(15 Ulasan)
3.7
bohdansmoliar

Hi, I am a sql expert who has 5 years of experience. I can do this quickly. I would like to discuss more via chat. Thank you.

€20 EUR dalam sehari
(5 Ulasan)
3.7
rjramanayake

SQL expert here. Can complete your task within 30 minutes. Please feel free to contact me and discuss further. High quality work will be returned meeting your deadline and budget, follow up work and support is guarant Lagi

€15 EUR dalam sehari
(10 Ulasan)
3.2
gryndanya

SQL developer experience over 4 years I can start working immediately. Let's discuss details in chat. Thanks

€30 EUR dalam 2 hari
(15 Ulasan)
3.1
nadezhda319

Dear Client. Hope you are doing well. ⭐⭐⭐I am SQL expert.⭐⭐⭐ High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I am a full-stack developer who has rich experience in web devel Lagi

€30 EUR dalam sehari
(4 Ulasan)
2.2
(4 Ulasan)
2.3
GeorgeP1979

Hi there! I can help you with your script. Which database are you using? MySql? If you assign me the task I can start working right now. Thanks, George

€10 EUR dalam sehari
(2 Ulasan)
1.6
jyotit371

Hello , there I have read your requirements. I have 5 + years of experience in same technologies c#, asp.net, jQuery and MySQL, SQL server I will do my best to deliver you quality of work on time . Please give me one Lagi

€10 EUR dalam 7 hari
(1 Ulasan)
1.7
dsinfoways

Hello Sir, I have gone through your requirements regarding run a query in SQL. we brief and understand your idea and preference for job as you are looking for. I have more than 10+ years of experience in .NET, .NET C Lagi

€19 EUR dalam sehari
(0 Ulasan)
0.0
vslav9966

Dear Client. Share with me your sql file if you possible. I am a SQL expert for over 15 years. I am able to start right now once we agreed all, and you will get a perfect query in a few hours. Looking forward to worki Lagi

€15 EUR dalam 3 hari
(1 Ulasan)
0.0