I am not able to rectify the problem
UPDATE tbl_delete SET delete='60' WHERE tablename='somereports'
The above code throws error the following error:
Error in Updation Query
UPDATE tbl_delete SET delete='60' WHERE tablename='somereports'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete='60' WHERE tablename='somereports'' at line 1
delete is a reserved word in MySQL, you should use backticks to escape it:
UPDATE `tbl_delete` SET `delete`='60' WHERE `tablename`='somereports'
Delete is reserved keyword in mysql in must be in backtick. OR change the column name which is not in the list of reserved keyword
UPDATE tbl_delete SET `delete`='60' WHERE tablename='somereports'
OR you can also write table name before column name as
UPDATE tbl_delete SET tbl_delete.delete='60' WHERE tbl_delete.tablename='somereports'
DELETE is a reserved keyword in MySQL so it's parsed like a keyword and not like a column name. MySQL expects valid DELETE syntax after the DELETE keyword but instead it "sees" an equals symbol (=). Wrap it in `` to fix the error like this:
UPDATE tbl_delete SET `delete`='60' WHERE tablename='somereports';
