run a query in SQL
€8-30 EUR
착불
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]:
프로젝트 ID: #31015260
프로젝트 소개
수상자:
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
이 일자리에 대한 프리랜서 24 명의 평균 입찰가: €19
Hello sir/madam... I can add 0 in front of ZIP code. Please, contact me to make deal Regards Vladimir
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 기타
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
Hi there. I am professional full stack web developer. I will be glad to help you. Please check my profile. Thanks.
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 기타
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.
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 기타
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.
SQL developer experience over 4 years I can start working immediately. Let's discuss details in chat. Thanks
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 기타
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 기타
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.
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
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 기타
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.
Hi I have good experience in sql and I can finish it right away in minutes. Please give me a chance to finish work