Home / MySQL / MySQL online tutorial – Column Types part 2
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");
How do I view a deleted web page?
Is there a way to view a deleted web page - one that is no longer available? Yes there is and the solution is quite simple. [more...]
Howard Cunningham, creator of wiki software and the world's first wiki web site (WikiWikiWeb), came up with the name after being told to take the 'Wiki Wiki Shuttle' at the Honolulu airport. "Wiki" means "quick" in Hawaiian. The first wiki site is still up and running at the server of his software consultancy firm, Cunningham & Cunningham. [more...]
We use cookies to give you the best possible website experience. By using WebDevelopersNotes.com, you agree to our Privacy Policy