Adding new enum column to an existing table

mysql enums alter
max85 picture max85 · May 9, 2015 · Viewed 34.9k times · Source

I'm trying to add a gender column to my table with this query: 

ALTER TABLE QRCodeUser ADD gender CHAR(1) enum('M','F') NOT NULL;

I get this error:

#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 'enum('M','F') NOT NULL' at line 1

What's my mistake?

Answer

dsharew picture dsharew · May 9, 2015

Try this (you dont need to specify the size, char(1) ) : 

ALTER TABLE QRCodeUser ADD gender  enum('M','F') NOT NULL;

Related questions

How do I add more members to my ENUM-type column in MySQL?

The MySQL reference manual does not provide a clearcut example on how to do this. I have an ENUM-type column of country names that I need to add more countries to. What is the correct MySQL syntax to achieve this? …

Read More
Specifying a mySQL ENUM in a Django model

How do I go about specifying and using an ENUM in a Django model?

Read More
MyBatis enum usage

I know this has been asked before, but I wasn't able to implement a solution based on the information I found so far. so perhaps someone can explain it to me. I have a table "status". It has two columns:…

Read More