In oracle-db it is possible to insert values from table A to table B like

```
Insert into table_a values
 Select * from table_b where ID = 10
;

```

If the structures are the same.
How can I do this in MYSQL? My Editor gave me an sytanx-error.

Thx 4 your answers!

Greetz