You are viewing a single comment's thread from:

RE: SQL Basics: When To Use SELECT * INTO

in STEMGeeks • 4 years ago

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.

4 years ago in STEMGeeks by
$0.00
    6 votes
    Reply 1
    Sort:  
  • Trending
    • [-]
     4 years ago  

    Yes, some SQL languages support it, some don't. Most SQL languages have something similar and they work in a similar way where some of the schema is copied, while some is not (like defaults). In this example, I use a specific SQL platform, SQL Server, to demonstrate this, but it would vary by SQL tool.