Need help with mysql insertvalues

[Chrysanthus]

Hi need help with values for mysql...

Whats is wrong with my syntx? what should it be.

i have read the mysql manuel but i dosent help!

CREATE TABLE table_members
(id int(11) NOT NULL auto_increment,

this field should be only letters and support for ÅÄÖ
firstname varchar(32) default NULL,
check (firstname~'^{[a-öA-Ö]+$'))}
Gets a error

this field should be only letters and support for ÅÄÖ
lastname varchar(32) default NULL,
check (lastname~'^{[a-öA-Ö]+$'))}
Gets a error

gender char(1) default NULL check (gender in('M','K','W'))

this field should be only numbers
birth varchar(10) default NULL
check (birth~'^[0-9]+$'))
Gets a error

this field should the be @ in it
epost varchar(32) default NULL check (epost~'@'))
Gets a error

username varchar(60) default NULL check (username~'^{[a-zA-Z]+$'))} UNIQUE,

password varchar(32) default NULL,

PRIMARY KEY(id));

---

// leif

[Sxooter]

The problem is that MySQL doesn't support check constraints or regular expressions. Postgresql can run this code though. Most databases have check constraints, and many have regex capability, but not always as well implemented as I'd like.

According to the MySQL manual, checking the input data for correctness is the job of your external code.

Note that it will process check contraints, it just doesn't use them. nice huh?

[Chrysanthus]

ok thanks

i will fix it on the php app!