为什么 phpmyadmin 不为枚举类型创建值? [英] Why phpmyadmin does not create values for enum type?

问题描述

我是 mysql 的新手，所以我使用 phpmyadmin 在数据库中创建表.我有枚举类型的字段制造商，可能值为manufacturer1"，manufacturer2"，...

I am new to mysql so I am using phpmyadmin to create table in database. I have field Manufacturer of enum type with possible values "manufacturer1", "manufacturer2", ...

我选择了 ENUM 类型并单击了编辑 ENUM/SET 值"，然后会弹出一个询问所需值的窗口.我听从指令，按go"，Manufacturer1"、Manufacturer2"、Manufacturer3"、Manufacturer4"没有写在长度/值中.

I chose ENUM type and clicked on "Edit ENUM/SET values" and a window pop up asking for desired values. I fallow the instructions, press "go" and 'Manufacturer1','Manufacturer2','Manufacturer3','Manufacturer4' is no written in Length/Values.

当我尝试创建表时，出现 1064 语法错误.当我点击预览 SQL"时，我得到了这个:

When I try to create table I get 1064 syntax error. When I click on "Preview SQL" I get this:

CREATE TABLE `test4_db`.`product` ( `product_id` INT(11) NOT NULL AUTO_INCREMENT , `image_url` VARCHAR(255) NOT NULL , `manufacturer` ENUM(0) NOT NULL DEFAULT 'Manufacturer1' , `health` ENUM(0) NOT NULL , `missing` INT(11) NOT NULL , `statuss` ENUM(0) NOT NULL DEFAULT 'available' , `owner_id` INT(11) NOT NULL , `holder_id` INT(11) NOT NULL , PRIMARY KEY (`puzzle_id`)) ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_bin;

为什么 phpmyadmin 写的是 ENUM(0) 而不是 ENUM('Manufacturer1','Manufacturer2','Manufacturer3','Manufacturer4')?

Why does phpmyadmin writes ENUM(0) instead of ENUM('Manufacturer1','Manufacturer2','Manufacturer3','Manufacturer4')?

推荐答案

这是 phpMyAdmin 4.6.4 的一个错误.

This is a bug with phpMyAdmin 4.6.4.

看到这个 - https://github.com/phpmyadmin/phpmyadmin/issues/12480

这将在 4.6.5 中修复.

This will be fixed in 4.6.5.

同时，您可以简单地执行Preview SQL"，复制生成的 SQL，并将 ENUM(0) 替换为您想要的值.

In the meanwhile, you can simply do "Preview SQL", copy the SQL generated, and replace ENUM(0) with the values you want.

或者，使用以前版本的 phpMyAdmin.

Alternatively, use a previous version of phpMyAdmin.

这篇关于为什么 phpmyadmin 不为枚举类型创建值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！