column constraint in mysql

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarKo - 25 Jan 2005 13:11 GMT

hi to everybody,

is it possible to constrain the values that can be inserted in a field
(i.e. field > 10)?

Reply to this Message

Thomas Kellerer - 25 Jan 2005 13:38 GMT

I have no experience with MySQL but shouldn't things like that be documented in
the user manual?

Thomas

> hi to everybody,
>
> is it possible to constrain the values that can be inserted in a field
> (i.e. field > 10)?

Reply to this Message

MarKo - 25 Jan 2005 14:09 GMT

Hi Thomas,

unfortunately on the manual on line there isn't any reference.
I have tried to do create table this way:

...
Tag INTEGER NOT NULL CHECK(Tag>10),
...

but when I make an INSERT it do any control.

Thomas Kellerer ha scritto:

> I have no experience with MySQL but shouldn't things like that be documented in
> the user manual?
>
> Thomas

Reply to this Message

Christopher Browne - 25 Jan 2005 23:24 GMT

After takin a swig o' Arrakan spice grog, MarKo <marko@ka.com> belched out:

> hi to everybody,
>
> is it possible to constrain the values that can be inserted in a field
> (i.e. field > 10)?

I am led to believe that some versions of their product accept some
form of SQL "constraint" DDL, but that it is not necessarily acted on.

Have you considered checking with the vendor to see if they document
the feature?

Signature

let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/rdbms.html
"I have never seen the inside of the building at Microsoft where the
top executives hang out, but I have this fantasy that in the hallways,
at regular intervals, big red alarm boxes are bolted to the wall. Each
contains a large red button protected by a windowpane. A metal hammer
dangles on a chain next to it. Above is a big sign reading: IN THE
EVENT OF A CRASH IN MARKET SHARE, BREAK GLASS." -- Neal Stephenson

Reply to this Message