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.  =:\

        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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to