SQL statement to execute through PHPMyAdmin

$10-30 USD

Завершено

Опублікований

over 6 years ago

$10-30 USD

Оплачується при отриманні

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.

Database Administration

ID проекту: 15546638

Про проект

21 пропозицій(-ї)

Дистанційний проект

Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@r3dtime

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 за 0 день

5,0

(24 відгуки(-ів))

5,1

21 фрілансерів(-и) готові виконати цю роботу у середньому за $22 USD

@professional1248

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 за 1 день

5,0

(127 відгуки(-ів))

6,7

@pivn

Let me help you Relevant Skills and Experience SQL Proposed Milestones $20 USD - SQL

$20 USD за 1 день

4,9

(215 відгуки(-ів))

6,7

@MrMSparrow

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 за 1 день

5,0

(65 відгуки(-ів))

6,4

@ferozstk

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 за 1 день

4,9

(78 відгуки(-ів))

6,2

@liviuconcioiu

Can help you right away. Relevant Skills and Experience See my Feedback Proposed Milestones $10 USD - Milestone Let's chat

$10 USD за 1 день

5,0

(46 відгуки(-ів))

4,9

@dataenterworker

give sql query Relevant Skills and Experience give sql query Proposed Milestones $25 USD - give sql query give me your skype id

$25 USD за 1 день

5,0

(31 відгуки(-ів))

4,4

@NumanAnjum

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 за 1 день

5,0

(13 відгуки(-ів))

4,3

@solyz

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 за 1 день

5,0

(6 відгуки(-ів))

4,5

@mbjinfosolution

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 за 1 день

5,0

(1 відгук)

1,2

@karthvks

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 за 1 день

0,0

(0 відгуки(-ів))

0,0

@mrechodie

hi there i can do it contact me Relevant Skills and Experience mysql Proposed Milestones $25 USD - complete work

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@HCoders

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 за 1 день

0,0

(0 відгуки(-ів))

0,0

@syedasifuddin92

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 за 1 день