MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.17

CREATE TABLE fred (mary int, paul varchar(20))
INSERT INTO fred VALUES (1, 'sdf'), (2, 'xxx'), (3, 'yyy')
SELECT * FROM fred

mary
paul

1
sdf

2
xxx

3
yyy

CREATE TABLE bill AS SELECT * FROM fred WHERE mary <= 2
SELECT * FROM bill

mary
paul

1
sdf

2
xxx

SELECT * INTO TABLE mark FROM fred WHERE mary <= 2
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 'TABLE mark FROM fred WHERE mary <= 2' at line 1

SELECT * FROM mark
Table 'fiddle_ZBKTZYDVJKVQPXWFMNBW.mark' doesn't exist