Text can be fixed length (char) or variable length strings. Also, text comparisons can be case sensitive or insensitive depending on the type you choose.
m_status ENUM("Y", "N")
Thus, m_status column will take only Y or N as values. If you specify any other value with the INSERT statement, MYSQL will not return an error, it just inserts a NULLvalue in the column.
hobbies SET ("Reading", "Surfing", "Trekking", "Computing")
You can have 0 or all the four values in the column.
INSERT tablename (hobbies) values ("Surfing", "Computing");
The WWW was invented by Sir Tim Berners-Lee on the NeXTSTEP operating system. The same OS forms the source of Apple's OS X, iOS, watchOS and tvOS. NeXTSTEP was originally written for the NeXT computer and is based on UNIX. [more...]