I have an access db with populated fields, some of them are date fields. One is a created date and another is a updated date. I haven't tried it yet, so I am not sure what I will get but I assume that if I am asking MySQL to automatically update these fields rather than manually have to fill them in, I would lose the correct dates? Will MySQL replace the original dates with that of the current date? If so, how can I overcome this?
The Access db I have doesn't have any automatic formatting for the date fields at the moment, but I want to introduce it in the MySQL version.
Thanks
Mat
I don't think you can tell MySQL to set a default date value of the current date. There is the timestamp field, which will show you when the record was last altered, but I wouldn't use that. I would create 2 date fields and have Access set them to what you want. That works best for me anyway.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
