Altering column data SQL
Error code 1064  :


This means you have an error in your SQL syntax.( ; missed)

 Select Model, Variant, EngineSize, RegYear, Mileage, Price, Sector 
 from sampledata ;
 update sampledata
 set RegYear = 2010 - RegYear
 where sector = 'Van Derived Cars'
 and mileage &gt; 200
 and regyear != -1
 and price != 999999;



  Mysql error  code 1175 :


If you are in a safe mode, you need to provide a key (ex. primary key) in the where clause or you can SET SQL_SAFE_UPDATES = 0;