I didn't know it's part of the SQL-standard, thought it was something postgres-specific.
MySQL doesn't support it ... https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-select-into-table.html ... but according to the docs, mariadb supports it by now. Haven't tested it though.
RE: SQL Basics: When To Use SELECT * INTO