From: sono-io
Date: June 7 2011 1:24am
Subject: Data missing after field optimization
List-Archive: http://lists.mysql.com/mysql/225187
Message-Id: <BDC073FF-D5B4-4683-8F59-88C07A374368@fannullone.us>
MIME-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

	Hopefully I won't look like too much of a numbskull here but =
after reading some sites on table optimization, I decided to remove the =
NULL as default on the fields in my products table.  I thought =
everything went well until I realized that we hadn't received any orders =
for 2 days.  That's when I realized that my products table was empty!  =
Luckily this happened over the weekend.  =3D:\

	I've made changes to field types before and never had a problem =
like this.  Does anyone know what went wrong from my limited =
description?  Why would removing the NULL default cause data to be lost?

Thanks,
Marc=