Find Jobs
Hire Freelancers

SQL statement to execute through PHPMyAdmin

$10-30 USD

Completed
Posted over 6 years ago

$10-30 USD

Paid on delivery
I need help with a SQL statement that I want to execute through the PHPMyAdmin web interface. The table: oc_product_option_value The column with the existing value: option_value_id The column which needs updating: model I want to update one column depending on the value in another column. For example, all the rows which have the value of "55" in the option_value_id column, insert the word "fungus" in the model column. The model column may or may not already have a value but this must be overwritten with the new value. I will want to run this statement about 5x and will manually change the values for each execution. Ideally someone who has Skype messenger and is available now.
Project ID: 15546638

About the project

21 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
UPDATE table_name SET model = 'fungus' WHERE option_value_id = 55; Relevant Skills and Experience 10+ years experience in web/app dev, can start now Proposed Milestones $10 USD - on finish
$10 USD in 0 day
5.0 (24 reviews)
5.1
5.1
21 freelancers are bidding on average $22 USD for this job
User Avatar
hey i can do this for you please text me Relevant Skills and Experience hey i can do this for you please text me Proposed Milestones $15 USD - fuli
$15 USD in 1 day
5.0 (127 reviews)
6.7
6.7
User Avatar
Let me help you Relevant Skills and Experience SQL Proposed Milestones $20 USD - SQL
$20 USD in 1 day
4.9 (215 reviews)
6.7
6.7
User Avatar
Will help with MySQL statement to change values in database as required Relevant Skills and Experience Expert in databases such as MySQL and available to complete this now. Proposed Milestones $30 USD - Create query to change values
$30 USD in 1 day
5.0 (65 reviews)
6.4
6.4
User Avatar
Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on with more than 5 years experience. Please feel free to contact me. I am looking forward to hear from you. Best regards
$30 USD in 1 day
4.9 (78 reviews)
6.2
6.2
User Avatar
Can help you right away. Relevant Skills and Experience See my Feedback Proposed Milestones $10 USD - Milestone Let's chat
$10 USD in 1 day
5.0 (46 reviews)
4.9
4.9
User Avatar
give sql query Relevant Skills and Experience give sql query Proposed Milestones $25 USD - give sql query give me your skype id
$25 USD in 1 day
5.0 (31 reviews)
4.4
4.4
User Avatar
Hey there! i have read your description. i have about +3 years experience in databases .i can help you . lets share further details in chat. thanks, Relevant Skills and Experience Databases , PHPMyAdmin , sql , Proposed Milestones $15 USD - Finalized Work
$15 USD in 1 day
5.0 (13 reviews)
4.3
4.3
User Avatar
with over 14 years of software development and databases experience, can create a query for you which will do the job. Relevant Skills and Experience dbms, mysql, phpmyadmin, query builder, sql joins Proposed Milestones $25 USD - in the end.
$25 USD in 1 day
5.0 (6 reviews)
4.5
4.5
User Avatar
I am available now and ready to write the SQL which can update the model value. It would be great if you can provide me table structure or table in sql so I can write query to execute in once. Relevant Skills and Experience Mysql, PHP, Os-commerce experience of 8 years Proposed Milestones $25 USD - Write a sql update oc_product_option_value set model = 'fungs' where option_value_id = '55' This is example to update one column.
$25 USD in 1 day
5.0 (1 review)
1.2
1.2
User Avatar
Though new to Freelancer, I am a expert in sql with 3 years experience working with WisdmLabs. Can do your work easily. Relevant Skills and Experience Will give you the best solution after seeing your exact table. Proposed Milestones $25 USD - Required Query
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hi there i can do it contact me Relevant Skills and Experience mysql Proposed Milestones $25 USD - complete work
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
you want to execute through the PHPMyAdmin web interface. Relevant Skills and Experience phpmyadmin,sql 5year experience Proposed Milestones $15 USD - milestones if you are free we will discuss the project?
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can help you out with this. And I'm available right now. Relevant Skills and Experience I've been working to MySQL and other databases for lot of my Academic and personal projects. Proposed Milestones $25 USD - Finish the task
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi i can do SQL task on phpmyadmin Stay tuned, I'm still working on this proposal.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Leeds, United Kingdom
5.0
62
Payment method verified
Member since Nov 19, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.