DB_Forge, default value

DB_Forge, default value

mwhitney
Posting Freak
Posts: 1,101
Threads: 4
Joined: Nov 2014
Reputation: 95

#11

04-01-2015, 10:25 AM

This is version-dependent. From the MySQL documentation:

Quote:Before MySQL 5.6.5, support for automatic initialization and updating is more limited:

DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP cannot be used with DATETIME columns.

DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP can be used with at most one TIMESTAMP column per table. It is not possible to have the current timestamp be the default value for one column and the auto-update value for another column.

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide

Messages In This Thread

DB_Forge, default value - by danielsan - 12-26-2014, 01:11 AM

RE: DB_Forge, default value - by jlp - 12-31-2014, 05:36 PM

RE: DB_Forge, default value - by mwhitney - 01-02-2015, 02:16 PM

RE: DB_Forge, default value - by kenjis - 12-09-2015, 07:37 PM

RE: DB_Forge, default value - by danielsan - 01-03-2015, 11:24 AM

RE: DB_Forge, default value - by mwhitney - 01-05-2015, 03:13 PM

RE: DB_Forge, default value - by harpreet - 03-31-2015, 06:23 AM

RE: DB_Forge, default value - by CroNiX - 03-31-2015, 07:04 AM

RE: DB_Forge, default value - by harpreet - 03-31-2015, 07:09 AM

RE: DB_Forge, default value - by harpreet - 03-31-2015, 07:12 AM

RE: DB_Forge, default value - by CroNiX - 03-31-2015, 08:41 AM

RE: DB_Forge, default value - by mwhitney - 04-01-2015, 10:25 AM

RE: DB_Forge, default value - by CroNiX - 04-01-2015, 10:43 AM