MySQL Forums
Forum List  »  PHP

Mysql Enum field problems
Posted by: Domenico Casaccia
Date: July 23, 2021 01:17PM

in a mysql table I have a field of type Enum ('S', 'N') with default value = S. Now I have checked this table and I find many records that have no value in this field. How is it possible? I wanted to force the values of this field to be only S and N. Where did I go wrong?

Mysql version 5.0.92 my field definition:

conteggia enum('S','N') NOT NULL default 'S'

Options: ReplyQuote


Subject
Written By
Posted
Mysql Enum field problems
July 23, 2021 01:17PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.