如何在mysql中转换sql server查询 [英] how to convert sql server query in mysql

问题描述

从tbl_Source选择*进入tbl_Distination;

select * into tbl_Distination from tbl_Source;

推荐答案

MySQL服务器不支持SELECT ... INTO TABLE Sybase SQL扩展。相反，MySQL Server支持INSERT INTO ... SELECT标准SQL语法



SELECT INTO TABLE [ ^ ]

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

SELECT INTO TABLE[^]

这篇关于如何在mysql中转换sql server查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！