From: Martijn Tonies Date: November 6 2006 11:35am Subject: Re: Default Column Value List-Archive: http://lists.mysql.com/mysql/203155 Message-Id: <012601c70197$99a0f320$cd02a8c0@martijnws> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit > Alternatively one could use a "TRIGGER" that updates the start_yr_mo > whenever start_date is modified but I'm unsure if triggers are present > before 5.1. Triggers are new in 5.0 Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com