Find Jobs
Hire Freelancers

Quick help with SQL Query -- 2

$10-30 USD

Complété
Publié il y a plus d’un an

$10-30 USD

Payé lors de la livraison
Question 1: The following command will update just user 100 y value. I would like to apply the following command to multiple user id with one command, example between 100 and 1000. UPDATE `x` SET `y` = '1,2,3' WHERE `user`.`id` = 100; Question 2: I would also like to know how to add a number to the "y" column for multiple users if the number is not already applied to the user. I would like to do this to thousands of users with one command but only include 4 users in the example below. Example, i would like to add number 5 to multiple users y value. Some users already have 5. Is it possible to keep all existing data but only add 5 to all users who do not have 5? User 1 has y: 1,2,3 User 2 has y: 1,4,5 User 3 has y: 1,2,3 User 4 has y: 1,2,3,5
N° de projet : 35780607

Concernant le projet

24 propositions
Projet à distance
Actif à il y a 1 an

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
I can help you with sql server queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create sql queries for sql server database as per design, let me know when to proceed. I can work on future works for databases also if needed. I will work for cheapest budget within time, budget can be re negotiated again, send the details for the project. Please contact me asap. I have 12+ years of experience in database programming, website designing, powershell scripting and android development. Feel free to message me anytime if you need to discuss this further.
$10 USD en 1 jour
5,0 (9 commentaires)
4,4
4,4
24 freelances proposent en moyenne $26 USD pour ce travail
Avatar de l'utilisateur
Hey I can work on your project, I have good working experience in HTML,CSS,AJAX,JAVASCRIPT,PHP,MYSQL,LARAVEL,CODEIGNITER,JQUERY, Let's connect and do great work. Thank You
$80 USD en 1 jour
5,0 (234 commentaires)
6,6
6,6
Avatar de l'utilisateur
Hi i can complete the query for you. Please allow me to work with you. Let me know when you need it. Thanks Shihan
$15 USD en 1 jour
4,9 (327 commentaires)
6,8
6,8
Avatar de l'utilisateur
Hi, I went through your project description and I feel confident about this job. I am a full stack developer with over 7 years of experience in the industry including PHP, SQL, MySQL, Database Programming, Microsoft SQL Server Please come over chat and discuss your requirement in a detailed way. Thank You
$10 USD en 7 jours
4,9 (119 commentaires)
6,0
6,0
Avatar de l'utilisateur
Hello,. I have 10+ years of experience in mysql and i am sure that i can help you in writing query for update. Please have a look at my profile for past projects and reviews. Feel free to msg me anytime. Thanks Arpit g.
$20 USD en 7 jours
4,9 (46 commentaires)
5,7
5,7
Avatar de l'utilisateur
Hi , I have read the description and I can do it very well I'm a web developer with rich hands-on experience for 8 years. If you give me a chance, I will give you the good result. Please drop me a message for quick discussion. Thanks & Regards.
$30 USD en 1 jour
5,0 (9 commentaires)
5,3
5,3
Avatar de l'utilisateur
Hello Friend! We can do a 15-minute free call to discuss the project requirements and our work plan. I know "500-level things about Microsoft SQL Server". I have 7+ years of exceptional knowledge and experience in both Prod & Dev Environments. Please feel free to ask for adjustment if my Bid Amount or Hourly Rate does not suit your budget. On January 1, 2023, I asked Microsoft for a feature improvement, which was accepted by Bob Ward, Principal Architect at Microsoft. Feature Improvement Request: 201 Buckets Problem, Histograms & Single 8KB Page Limitation, Statistics in SQL Server. Warm regards, Kundan Bihari (Freelance, SQL Server Consultant.)
$20 USD en 1 jour
5,0 (34 commentaires)
5,0
5,0
Avatar de l'utilisateur
Hi, I can do this. I'm a Web Developer. I have working experience in PHP and MySQL web applications. I can fix it in less than an hour.
$27 USD en 1 jour
5,0 (23 commentaires)
5,2
5,2
Avatar de l'utilisateur
Dear client, this is a simple task, I'm ready to fix it ASAP. please let's discuss
$40 USD en 7 jours
4,9 (39 commentaires)
4,9
4,9
Avatar de l'utilisateur
Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping using python, -Database development in (Mysql,Postgres,SQlite and SQl) -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel and Tableau -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa
$30 USD en 1 jour
4,9 (34 commentaires)
4,8
4,8
Avatar de l'utilisateur
Hi there. ⭐⭐ I am a full stack Developer ⭐⭐ with experience in Power BI, C & C++ Programming, MY SQL, Machine Learning (ML), PYTHON, Deep Learning and Communications. I have worked with many similar projects as i have a team of enthusiastic developers. We strive to give our best. Please contact to discuss in detail.
$30 USD en 1 jour
5,0 (8 commentaires)
4,0
4,0
Avatar de l'utilisateur
Hello, I can write complex sql query for you. I have experience of mysql complex queries. If you give me this task I can start working on it instantly.
$15 USD en 1 jour
5,0 (6 commentaires)
3,3
3,3
Avatar de l'utilisateur
Hi, We have experienced PHP and MySQL developers on our team who can help you with your MySQL "ADD and Update" task. Looking forward to discussing the details via chat. Thanks
$30 USD en 3 jours
5,0 (2 commentaires)
3,1
3,1
Avatar de l'utilisateur
Hello I am a data analyst certified of udacity nano degree of data analysis using python and SQL I could make complex SQL queries contain sub queries and joins on MySQL I could make complex update queries and answer your questions Thank you
$15 USD en 1 jour
5,0 (3 commentaires)
1,7
1,7
Avatar de l'utilisateur
Hello, I have excellent experience in SQL(+7 years). I have read your requirements carefully, and I have extensive experience in this kind of project as I have done it before, so I can finish your project easily and rapidly in a professional way. Let's chat. Thanks
$30 USD en 1 jour
5,0 (1 commentaire)
1,0
1,0
Avatar de l'utilisateur
Hi, there. I just read your job posting and it sounds like you need an expert to build sql update query command. I can complete within 10 minutes perfectly. Let me know, if my proposal looks interesting, we can discuss project. Best regards.
$30 USD en 1 jour
5,0 (1 commentaire)
0,3
0,3
Avatar de l'utilisateur
hello i m computer scince student programmer and know computer language i done your work in little time i m good in programming
$20 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I have expirience with sql, nosql databases and i can do i to you so fast. That is so easy and it no problem for me.
$29 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi, I am a experienced full stack developer. I have 8 years of experience in software development. I will be able to get it done on time.
$10 USD en 7 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi , I have read your project description I Got your point i can help you out to write query for these Questions easily as i am learning competitive programming i will easily help you
$17 USD en 7 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi there, I have read your project about wanting to edit your sql query ,this can be done easily and efficiently by using sql's functions to answer both qeuestions My expertise usually involve the scraping of data from a website (selenium , BS4 , puppeteer) , cleaning the data (using python) then delving into the data using SQL and performing analysis , finally delivering a report of the finding to the client using powerbi tools I'm confident in my ability to complete your project on time and provide satisfactory results for you, I would to hear more about this project from you.
$10 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de MOROCCO
North Finchley, Morocco
5,0
15
Méthode de paiement vérifiée
Membre depuis mars 9, 2019

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.