At 2:57 PM +0200 2000-05-17, Fredrik Ericsson wrote:
>i'm new to MySQL and can't get the ENUM or SET types to work on my Linux
>system. I'm using Linux-mandrake 7.0 and MySQL 3.20. Here's what i do:
>mysql>create table test(username VARCHAR(20), interests ENUM('sports',
>I then get something like:"parse error near ENUM..." Isn't the ENUM and SET
>types supported on Linux? I've looked in the manual that came with the
>distribution and under supported types it says nothing about ENUM and SET..
>What can i do?
>Thanks in advance
MySQL 3.20 is pretty old; probably ENUM/SET weren't included then.
Paul DuBois, paul@stripped