Symfony：创建无效的 MySQL 代码？

发布于 2024-11-07 12:28:50 字数 839 浏览 0 评论 0原文

我正在阅读 Symfony 文档（Practical Symfony），并且我使用 propel 完成了 SQL 代码的创建。

但是当我尝试

$ symfony propel:insert-sql

MySQL 时，会抱怨：

#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 'Type=InnoDB' at line 7

生成的 MySQL 代码的片段：

CREATE TABLE `jobeet_category` (
`id` INTEGER NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 255 ) ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `jobeet_category_U_1` ( `name` )
) TYPE = InnoDB;

所以问题是 TYPE = InnoDB;，但我不明白为什么 propel 会生成无效代码。

我按照书中的所有说明进行操作，我不确定可能是什么问题 - 也许是我的 MySQL 版本？

编辑：我找到了答案。 http://zippykid.com/2010/05/symfony-mysql5-5-错误/

原文

I'm reading the Symfony documentation (Practical Symfony), and I finished creating the SQL code with propel.

But when i try to

$ symfony propel:insert-sql

the MySQL complains with:

#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 'Type=InnoDB' at line 7

Snippet of the produced MySQL code:

CREATE TABLE `jobeet_category` (
`id` INTEGER NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 255 ) ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `jobeet_category_U_1` ( `name` )
) TYPE = InnoDB;

So the problem is TYPE = InnoDB;, but I don't understand why did propel produce invalid code.

I followed all the instructions in the book, I'm not sure what could be the problem - maybe the MySQL version I have?

Edit: I found my answer. http://zippykid.com/2010/05/symfony-mysql5-5-error/

分享到QQ

分享到微博