run a query in SQL

완료 등록 시간: 2년 전 착불
완료 착불

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]:

SQL MySQL 마이크로소프트 SQL 서버 PHP SQLite

프로젝트 ID: #31015260

프로젝트 소개

24 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 2년 전

수상자:

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 (1일 이내)
(1 리뷰)
1.5

이 일자리에 대한 프리랜서 24 명의 평균 입찰가: €19

vladang

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

€20 EUR (1일 이내)
(155 리뷰)
6.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 기타

€15 EUR (1일 이내)
(41 리뷰)
5.1
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 (1일 이내)
(40 리뷰)
4.4
aodinaev000

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

€30 EUR (1일 이내)
(18 리뷰)
4.6
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 기타

€19 EUR (7일 이내)
(23 리뷰)
4.2
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 기타

€15 EUR (3일 이내)
(7 리뷰)
4.0
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 (7일 이내)
(17 리뷰)
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 기타

€29 EUR (1일 이내)
(18 리뷰)
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 (1일 이내)
(6 리뷰)
3.9
gryndanya

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

€30 EUR (2일 이내)
(19 리뷰)
3.2
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 기타

€30 EUR (1일 이내)
(5 리뷰)
2.4
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 기타

€10 EUR (7일 이내)
(1 리뷰)
1.6
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 기타

€19 EUR (1일 이내)
(0 리뷰)
0.0
sripsrk51

I will write the sql and send it immediaty. if you need further tweaking in case if you want to improve your scenario, I will do it in the same job.

€9 EUR (1일 이내)
(0 리뷰)
0.0
ibrahimRageh

welcome My Dear I can do that in short time you can talk with my and make this query and another query any time you need

€19 EUR (1일 이내)
(0 리뷰)
0.0
KavinduPro

Dear Customer, I am also a qualified and highly experienced for SQL so you won't have to worry about the quality of my work. Please trust me. I am looking forward to working with you on your project and achieving your 기타

€10 EUR (10일 이내)
(0 리뷰)
0.0
DivyasriMuram

I can write the query for you. I have very good knowledge on SQL Server. Please ping me I can give you the query within minutes.

€19 EUR (1일 이내)
(0 리뷰)
0.0
rajeshnv19rajesh

Hi I have good experience in sql and I can finish it right away in minutes. Please give me a chance to finish work

€26 EUR (1일 이내)
(0 리뷰)
0.0