php - 为什么 Doctrine 无法清除我的数据库？ Doctrine 的语法错误

每当我试图加载数据设备时，都会出现此错误：

  [Doctrine\DBAL\DBALException]
  An exception occurred while executing 'DELETE FROM Group':

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
  n your SQL syntax; check the manual that corresponds to your MySQL server v
  ersion for the right syntax to use near 'Group' at line 1

我不想修改条令，但显然它没有使用正确的语法。我需要以不同的方式配置条令吗？我将smyfony2与mysql和基本原则包一起使用。下面是我的composer.json文件：

"require": {
    "php": ">=5.3.3",
    "symfony/symfony": "2.3.*",
    "doctrine/orm": ">=2.2.3,<2.4-dev",
    "doctrine/doctrine-bundle": "1.2.*",
    "twig/extensions": "1.0.*",
    "symfony/assetic-bundle": "2.3.*",
    "symfony/swiftmailer-bundle": "2.3.*",
    "symfony/monolog-bundle": "2.3.*",
    "sensio/distribution-bundle": "2.3.*",
    "sensio/framework-extra-bundle": "2.3.*",
    "sensio/generator-bundle": "2.3.*",
    "incenteev/composer-parameter-handler": "~2.0",
    "doctrine/orm": "*",
    "phpunit/phpunit": "3.7.*",
    "doctrine/doctrine-migrations-bundle": "dev-master",
    "doctrine/migrations": "dev-master",
    "doctrine/doctrine-fixtures-bundle": "dev-master",
    "doctrine/data-fixtures": "dev-master",
    "ircmaxell/password-compat": "dev-master"
},

最佳答案

Group是mysql中的关键字。所以你可能想逃离它。

DELETE FROM `Group`

关于php - 为什么 Doctrine 无法清除我的数据库？ Doctrine 的语法错误，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/17509227/