How do i make mysql fail to insert a row when some column is not set? -

I'm running into a problem where a row is not particularly specific to the INT column (column defaults to 0

I can create the table in this way:

  table inventorycontrol (id INT not unique NULL unique AUTO_INCREMENT, nodeID INT not create NULL probe (nodeID & Nbsp; 0), custom1 VARCHAR (128) No NULL default, custom2 VARCHAR (128) No NULL default ', custom3 VARCHAR (128) No NULL default', custom4 VARCHAR (128) No NULL default '', articlekey VARCHAR 32) No NULL, Amount INT no NULL, OrderID INT zero, supplierID INT zero, customer ID INT zero, DateCreated DATETIME No NULL, expectedCO Receipt DATETIME Faucet, Date Completed Date, Zero, Primary Key (as per the date, date)) Create indicator ix_InventoryArticle ON Inventory Control (Articles) You can create indices IX_InventoryArticle_Custom On Inventory Control (Index 1, Custom 2, Custom 3, Custom 4) index to create index ix_InventoryAmount on inventory control amount) Index ix_InventoryCreated Make the GO (DateCreated) index on the inventorycontrol ix_InventoryCompleted on the inventorycontrol GO (datecompleted) GO ALTER The table inventorycontrol add the foreign key fk_nodeID (nodeID) to the reference node (id) GO  

I will not insert this Expected to:

Is there any way that I get this To join I Milit reduction to make the trigger to be bound to fail?

Thanks in advance,

>

Chris

PS I am using mysql Ver 14.12 Distrib 5.0.45, redhat-linux-gnu (x86_64 ) Using Redline 5.0 for