write a sql query to modify the column ‘title” as ‘PHYSICS Volume-I’ in the ‘Books’ table where the ‘Title’ column has ‘PHYSICS-I’.
I tried to put a query for this like ( update Books set title=PHYSICS Volume-I where Title=PHYSICS-I; )
But it shows incorrect syntax near ‘Volume’.
New contributor
Sushmi Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.