I have this query:

> 
> select \* from weather where ICAO = 'SSPB' and timestamp =
> (select max(timestamp) from weather where ICAO = 'SSPB');
> 
> 
> 

the result:

---

```
timestamp, ICAO, time, wind_angle, wind_speed, gust, visibility, condition, sky, temp, dew, pressure, humidity

2018-04-02 19:20:01, SSPB, 021919, 230, 03, , 9999, , SCT026, 23, 17, 1012, 67%

```

---

Now I wanto to update, using the same method as the select

> 
> update weather set wind\_speed = '10' where ICAO = 'SSPB' and
> timestamp = (select max(timestamp) from weather where ICAO = 'SSPB');
> 
> 
> 

I get this error:

Error Code: 1093. You can't specify target table 'weather' for update in FROM clause
====================================================================================