MySQL:错误#1193 - 未知的系统变量 'QUOTED_IDENTIFIER'

Question

我尝试在 PHPMyAdmin 中执行 SQL 语句，但收到一条错误消息:

Error #1193 - Unknown system variable 'QUOTED_IDENTIFIER' 

SQL语句如下:

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[FFT_DG_REC_4](
    [time] [bigint] NULL,
    [c1] [int] NULL,
    [c2] [int] NULL,
    [c3] [int] NULL,
    [c4] [int] NULL,
    [c5] [int] NULL,
    [c6] [int] NULL,
    [c7] [int] NULL,
    [c8] [int] NULL,
    [c9] [int] NULL,
    [c10] [int] NULL,
    [c11] [int] NULL,
    [c12] [int] NULL,
    [c13] [int] NULL,
    [c14] [int] NULL,
    [c15] [int] NULL,
    [c16] [int] NULL,
    [c17] [int] NULL,
    [c18] [int] NULL,
    [c19] [int] NULL
) ON [PRIMARY]

GO

我该如何更正此陈述以解决问题？

Answer 1

QUOTED_IDENTIFIER 是一个 Transact-SQL 设置，而您可能将 MySQL 与 PhpMyAdmin 结合使用。此设置在 MySQL 中不可用，您需要使用 ANSI_QUOTES 代替。查看this topic了解更多信息。