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

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

Sorry, you can't reply to this topic. It has been closed.

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.