On 10/5/07, Rumi Tsekova <rtsek...@openlinksw.com> wrote:
> You can add check constraint either in the create table statement, or add it
> afterwards.
>
> i.e. for ex.:
>
> create table person (
> name varchar,
> likes_fruits varchar CHECK ( likes_fruits in ('apple', 'pear','orange'))
> );Yes, but I'm not so much bothered about following constraints as about saving storage space. The MySQL implementation just uses a small dictionary for the column values and only stores references to those in the column. I know - it's the same as creating a separate foreign key table, but sometimes this is quite much overhead and I think that's what made MySQL so sucessful - many handy features, which make everyday work really fun. I will try to make a collection of such handy MySQL features and then maybe we can have a migration guide for MySQL users ;-) Anyway, thanks for the reply Sören
