mysql - SQL SELECT ... INTO 简介 - 为什么它不运行？

Question

我正在运行 SQL 服务器，需要使用 SELECT ... INTO 命令运行一些命令。目前(作为测试)我正在运行这个命令:

SELECT * 
INTO `assets_copy` 
FROM `assets`

可能是最简单的示例，但它仍然无法运行。我收到错误:

MySQL said:  

#1064 - 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 'assets_copy` FROM `assets`  LIMIT 0, 30' at line 1 

所以我想知道我使用的 SQL 版本是否不支持这个？我正在使用 MySQL 3.23.49。

Answer 1

Based on the documentation , MySQL 不支持 SELECT INTO 语法。相反，你必须使用

INSERT INTO assets_copy
  SELECT * FROM assets;

MySQL Server doesn't support the SELECT ... INTO TABLE Sybase SQL extension. Instead, MySQL Server supports the INSERT INTO ... SELECT standard SQL syntax, which is basically the same thing.