In the last episode (Jul 12), Larry Irwin said:
> I'd like to set up my CREATE's to have CHECK and REGEXP but can't
> seem to get 4.0.2 to accept my attempts...
> CREATE TABLE IF NOT EXISTS aptype (
> aptype_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
> appt_type VARCHAR(3) NOT NULL,
> branch VARCHAR(2),
> print_ticket VARCHAR(1), CHECK (SELECT (print_ticket) REGEXP "[0-9]"),
> print_on_stmt VARCHAR(1), CHECK (print_on_stmt IN "Y|N|E|R"),
> produce_ticket VARCHAR(1), CHECK (produce_ticket REGEXP [ASP])
> ) TYPE=InnoDB;
* The `FOREIGN KEY', `CHECK', and `REFERENCES' clauses don't
actually do anything. The syntax for them is provided only for
compatibility, to make it easier to port code from other SQL
servers and to run applications that create tables with references.
*Note Differences from ANSI::.
Just remove the CHECK() clause completely.
|• CHECK syntax||Larry Irwin||12 Jul|
| • Re: CHECK syntax||Dan Nelson||12 Jul|