I'm trying to figure out how to make Active's null as FALSE and '1' as TRUE,
in enum point of view....
Can anyone help me out here, trying to learn enum's phenomenon? I'm not sure
I understood document quite clear -- as of yet.... :(
mysql> desc Associate;
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| LocationID | int(11) | YES | | NULL | |
| NTLogon | varchar(8) | YES | | NULL | |
| DomainID | int(11) | YES | | NULL | |
| LastName | varchar(30) | YES | | NULL | |
| FirstName | varchar(30) | YES | | NULL | |
| Shift | int(11) | YES | | NULL | |
| QADE | enum('','1') | YES | | NULL | |
| DataEntry | enum('','1') | YES | | NULL | |
| QAMR | enum('','1') | YES | | NULL | |
| MailRoom | enum('','1') | YES | | NULL | |
| QAT | enum('','1') | YES | | NULL | |
| Taping | enum('','1') | YES | | NULL | |
| QAF | enum('','1') | YES | | NULL | |
| Filming | enum('','1') | YES | | NULL | |
| CustomerContact | enum('','1') | YES | | NULL | |
| Trainee | enum('','1') | YES | | NULL | |
| Active | enum('','1') | YES | | NULL | |
| Creator | varchar(8) | YES | | NULL | |
| NewAssociateDate | date | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
20 rows in set (0.00 sec)
mysql> select count(*) from Associate where Active=FALSE;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.01 sec)
mysql> select count(*) from Associate where Active=TRUE;
+----------+
| count(*) |
+----------+
| 2611 |
+----------+
1 row in set (0.01 sec)
mysql> select count(*) from Associate;
+----------+
| count(*) |
+----------+
| 3947 |
+----------+
1 row in set (0.00 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
