Set NOW() as Default Value for datetime datatype?
I have two columns in table users namely registerDate and lastVisitDate which consist of datetime data type. I would like to do the following. Set registerDate defaults value to MySQL NOW() Set lastVisitDate default value to 0000-00-00 00:00:00 Instead of null which it uses by default. Because the table already exists and has existing records, … Read more