Re: does the create table supports checks on column definition on mysql???

[VVM Ravikumar Sarma Chengalvala]

Hi,
The answer :No
Ravi
--- Pablo Fraga <[EMAIL PROTECTED]> wrote: > part
of database structure
> 
> example:
>  
> Create table cliente (
>  idcliente Int(8) NOT NULL,
>  nombre Varchar(30) NOT NULL,
>  idzona Int(5) NOT NULL,
>  zipcode Varchar(8),
>  direccion Varchar(30) NOT NULL,
>  idasiscom Int(5) NOT NULL,
>  listaprecio Int(2) NOT NULL,
>  diasvencimientofactura Int(2) NOT NULL,
>  iva Char(1) NOT NULL Check (S, s, N, n, I, i ),
>  idmonedafacturacion Int(3) NOT NULL,
>  controltopecredito Int(1),
>  topecredito Decimal(9,2),
>  estadoregistro Char(1) NOT NULL Check (P, A, I ),
>  estadodescripcion Varchar(30),
>  fechaalta Date NOT NULL,
>  idusuario Int(5) NOT NULL,
> Primary Key (idcliente)
> )  ;
> Pablo Fraga (MIS).
> e-mail: 
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> 


____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php