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.
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
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
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
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
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.
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.
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
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?
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