Hi everybody Has some way to set up a function, like now(), as a default value of an dateTime column. Is some thing like this.
Create Table Persons ( PersonCode int(10) zerofill not null auto_increment, PersonName varchar(150) not null, CadastreDate DateTime not null default now(), Primary Key (PersonCode)) Engine=MyIsam I am not want to transfer the responsibility of populate CadastreDate column to layers up. Who is the best solution ? Allyson Roberto Alves Cavalcanti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]