Create table in a mysql database

Question

I'm trying to import a database and I have a mistake which says that I have a mistake near the last 1, where is my mistake?, I don't find it. Could you please help me?.

CREATE TABLE cluw.envios_service_desk (
id_envio_sd int(10) NOT NULL,
id_cuenta int(10),
id_usuario int(10),
enviado enum(1),
f_envio datetime,
tipo_envio enum(1),
PRIMARY KEY (id_envio_sd)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If it is always set to be 1, why bother?

hjpotter92
– hjpotter92

2012-09-09 00:48:51 +00:00
Commented Sep 9, 2012 at 0:48 — hjpotter92
– hjpotter92, Commented Sep 9, 2012 at 0:48

Hawili · Accepted Answer · 2012-09-08 22:17:47Z

2

enum deals with strings only

to fix it just add small quotes around them like this

CREATE TABLE cluw.envios_service_desk (
id_envio_sd int(10) NOT NULL,
id_cuenta int(10),
id_usuario int(10),
enviado enum('1'),
f_envio datetime,
tipo_envio enum('1'),
PRIMARY KEY (id_envio_sd)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

answered Sep 8, 2012 at 22:17

Hawili

1,65911 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create table in a mysql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related