From: Peter Brawley
Date: June 16 2005 5:04pm
Subject: Re: Primary Key Question
List-Archive: http://lists.mysql.com/mysql/185552
Message-Id: <42B1B137.6010403@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hendro,

In SQL an empty string is not null.

PB

Hendro Suryawan wrote:

> Hi all,
> I have table with primary key on field PO,BrgId, NOSP but when i try
> insert several new reccord with field NOSP = '', mysql will accept the
> new reccord without complaint error.
> Is this normal behavior? My perception if i have primary key on the
> three field the three field must be not empty.  I try to alter the field
> NOSP with syntax :
>    Alter table BrgIn2 Change NOSP NOSP Varchar(20) NOT NULL
>
> but if i looked table definition mysql always add default '' in the
> definition. How to tell mysql not to add default '', i want to this
> field always not null or ''. I use mysql 4.1.11 on FC3 X86_64.
> Can anyone help? Thanks in advance.
> regards,
>
> Hendro
>
> Table   Create Table
> ------  ----------------------------------------------------
> BrgIn2  CREATE TABLE `BrgIn2` (
>          `PO` varchar(17) NOT NULL default '',
>          `BrgId` int(4) NOT NULL default '0',
>          `NoSP` varchar(20) NOT NULL default '',
>          `Spesifikasi` varchar(100) default NULL,
>          `Qty` decimal(10,3) NOT NULL default '0.000',
>          `Price` decimal(19,4) NOT NULL default '0.0000',
>          `Disc` decimal(6,4) default NULL,
>          `DPP` decimal(10,4) default NULL,
>          `Tax` decimal(6,4) default '0.0000',
>          `pph` decimal(6,4) default '0.0000',
>          `Kurs` decimal(10,4) default NULL,
>          `ShipDate` date default NULL,
>          `Currcy` varchar(10) NOT NULL default '',
>          `Keterangan` blob,
>          `Terima` decimal(9,2) default NULL,
>          `Periode` varchar(7) default NULL,
>          `TglInput` date default NULL,
>          `Operators` varchar(50) default NULL,
>          `Workstation` varchar(30) default NULL,
>          PRIMARY KEY  (`PO`,`BrgId`,`NoSP`),
>          KEY `BrgIn2SPBrg` (`NoSP`,`BrgId`,`Qty`),
>          KEY `BrgId` (`BrgId`)
>        ) ENGINE=MyISAM DEFAULT CHARSET=latin1
>
>
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.6/19 - Release Date: 6/16/2005