Hi, > [snip] > insert into property values ('','Book-keeper\'s Cottage','Thu'); > insert into property values ('','Inglenook Barn','Fri'); > insert into property values ('','Maggie\'s House','Fri'); > insert into property values ('','Riverside View',''); > insert into property values ('','The Manse',''); > insert into property values ('','Heathside',''); > select * from property; > > +-------------+-----------------------+-----------+ > | property_id | name | changeday | > +-------------+-----------------------+-----------+ > | 1 | Book-keeper's Cottage | Thu | > | 2 | Inglenook Barn | Fri | > | 3 | Maggie's House | Fri | > | 4 | Riverside View | | > | 5 | The Manse | | > | 6 | Heathside | | > +-------------+-----------------------+-----------+ > 6 rows in set (0.00 sec) > [/snip] > > All expected and correct behaviour. Why? Because you're specifying a > blank for the third value in the insert statement. > > insert into property values ('','Heathside',''); > insert into property values BLANK, Heathside, BLANK;
Yes, the DEFAULT doesn't apply. However, shouldn't MySQL raise an exception because '' isn't a valid value for this ENUM specification? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]