[SOLVED] SQL Update Syntax
Posted: Mon Sep 13, 2004 8:58 am
Hello,
I'm trying to update a table in MYSQL with three conditions. I dont know where i'm going wrong. Any help is appreciated.
Here is the code
My table has 5 coulms. I want to update the column "Value" based on three columns " Subject", "Type", and "Year".
I'm trying to update a table in MYSQL with three conditions. I dont know where i'm going wrong. Any help is appreciated.
Here is the code
Code: Select all
update data1 set value='98' where Subject='English', Type='School Score' and Year='01-02';