I was just reading through the Mysql manual section 3.32
And came across a sentence that started like this
Animal sex can be represented in a variety of ways
My mother tongue is not English but doesn't it sound rude ? :-)
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
VARCHAR is a good choice for the name, owner, and species columns
because the column values will vary in length. The lengths of those
columns need not all be the same, and need not be 20. You can pick any
length from 1 to 255, whatever seems most reasonable to you. (If you
make a poor choice and it turns out later that you need a longer field,
MySQL provides an ALTER TABLE statement.)
Animal sex can be represented in a variety of ways, for example, "m" and
"f", or perhaps "male" and "female". It's simplest to use the single
characters "m" and "f".
Query/mysql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
