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");
Apple didn't invent the mouse. It was built at SRI International by Douglas Engelbart and patented in 1970. Apple licensed it for about $40,000. Also, Apple wasn't the first company to attach a mouse to a computer. This had been done by Xerox on their 8010 Star personal computer, which unfortunately wasn't a success probably because of its steep price, a staggering $16,000. In addition to being the inventor of modern mouse, Douglas Engelbart is best remembered for giving a live demonstration of several computer technologies at the Fall Joint Computer Conference in San Francisco. This Mother of All Demos took place on 9th December 1968 and showcased windows, hypertext, graphics, video conferencing, word processing and, of course, the mouse.Mother of All Demos video on YouTube [more...]