What is the SQL command to change only the value in attribute \"EVIL_POWER\" to

Question

What is the SQL command to change only the value in attribute "EVIL_POWER" to "MIND_CONTROL" and consider only values in the attribute "AGE" that are greater than '10' for table "Monsters"

What is the SQL command to change only the value in attribute "EVIL POWER" to "Mind Control" and consider only values in attribute "AGE" that are greater than '10' for table "MONSTERS" Drag the options to the provided blanks to construct the SQL statement. WHERE EVIL POWER COLLECT SET MONSTERS "Mind Control" AGE Mind Control UPDATE SET io MONSTERS TABLE AGE 10 015 engage earning All Rights Reserved May not he scanned copied or duplirated or posted to a public acressible website. hole or in nart

Explanation / Answer

You can use below SQL query to change the value in attribute "EVIL_POWER" to "MIND_CONTROL"

This Query will only change the those data which has AGE grater than 10 in "Monsters" table.

UPDATE Monsters SET EVIL_POWER='MIND_CONTROL' WHERE AGE>10

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.