Assign Gender Field For Free

You can use a FOREIGN KEY to a reference table with just 2 rows: CREATE TABLE Gender_Ref ( gender CHAR(1) NOT NULL, PRIMARY KEY (gender) ) ENGINE = InnoDB ; INSERT INTO Gender_Ref (gender) VALUES ('F'), ('M') ; CREATE TABLE members ( id int(11) NOT NULL auto_increment, ... ...

Method Summary Modifier and TypeMethod and Descriptionstatic GendergetInstance(int code) Gets a gender object given a code.abstract inttoInt() Gets the numerical code of this gender.static GendervalueOf(java.lang.String name) Returns the enum constant of this type with the specified name.1 more row

Aside from what Hitomie mentioned, you can use also the dropdown field or a simple textbox (short text) field as your Gender field. These three are the preferred choices for creating a field for users to make gender selections.

Qualitative Data Type It means that this type of data can't be counted or measured easily using numbers and therefore divided into categories. The gender of a person (male, female, or others) is a good example of this data type.

Syntax: CREATE TABLE pets( ID INT NOT NULL, Name VARCHAR(30) NOT NULL, Breed VARCHAR(20) NOT NULL, Age INT, GENDER VARCHAR(9), PRIMARY KEY(ID), check(GENDER in ('Male', 'Female', 'Unknown')) ); Note: The check constraint in the above SQL command restricts the GENDER to belong to only the categories specified.

You can use a FOREIGN KEY to a reference table with just 2 rows: CREATE TABLE Gender_Ref ( gender CHAR(1) NOT NULL, PRIMARY KEY (gender) ) ENGINE = InnoDB ; INSERT INTO Gender_Ref (gender) VALUES ('F'), ('M') ; CREATE TABLE members ( id int(11) NOT NULL auto_increment, ... ...

Per the standard, the column should be called "Sex" and the 'closest' data type would be tinyint with a CHECK constraint or lookup table as appropriate.