MySQL Forums
Forum List  »  French

Champ not null
Posted by: Frederic Boyer
Date: November 12, 2008 01:50PM

Bonjour,
Comment expliquer le cas suivant. Avec PHPMyadmin j'execute le SQL suivant

CREATE TABLE `monde`.`Pays` (
`nom` VARCHAR( 20 ) NOT NULL ,
`capitale` VARCHAR( 20 ) NOT NULL ,
PRIMARY KEY ( `nom` )
) ENGINE = MYISAM

Tout fonctionne correctement, MEME en insérant un champ vide.
Cette instruction SQL est acceptée.

INSERT INTO `monde`.`Pays` (
`nom` ,
`capitale`
)
VALUES (
'', ''
);
Je souhaiterais ne pas pouvoir insérer de champs nul.
Avez vous une idée

Options: ReplyQuote


Subject
Views
Written By
Posted
Champ not null
5617
November 12, 2008 01:50PM
3155
November 13, 2008 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.