mhJn0qJh

1ALTER TABLE users MODIFY registerDate datetime DEFAULT NOW()
2ALTER TABLE users MODIFY registerDate datetime DEFAULT CURRENT_TIMESTAMP;
3	
4CREATE TABLE foo (
5    creation_time      DATETIME DEFAULT   CURRENT_TIMESTAMP,
6    modification_time  DATETIME ON UPDATE CURRENT_TIMESTAMP
7)
8	
9modification_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
10	
11CREATE TABLE mytable (
12  mydate TIMESTAMP
13)
14	
15CREATE TABLE mytable (
16  mydate TIMESTAMP DEFAULT CURRENT_TIMESTAMP
17)
18	
19CREATE TRIGGER `triggername` BEFORE INSERT ON  `tablename` 
20FOR EACH ROW 
21SET NEW.datetimefield = NOW()
22	
23ALTER TABLE `table_name` MODIFY COLUMN `column_name` TIMESTAMP NOT
24NULL DEFAULT CURRENT_TIMESTAMP;
25	
26`ALTER TABLE  `table_name` CHANGE `column_name` DATETIME NOT NULL DEFAULT 0
27	
28/************ ROLE ************/
29drop table if exists `role`;
30create table `role` (
31    `id_role` bigint(20) unsigned not null auto_increment,
32    `date_created` datetime,
33    `date_deleted` datetime,
34    `name` varchar(35) not null,
35    `description` text,
36    primary key (`id_role`)
37) comment='';
38
39drop trigger if exists `role_date_created`;
40create trigger `role_date_created` before insert
41    on `role`
42    for each row 
43    set new.`date_created` = now();
44	
45`ALTER TABLE  `table_name` CHANGE `column_name` 
46    timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 
47    ON UPDATE CURRENT_TIMESTAMP
48	
49ALTER TABLE my_table MODIFY created datetime(6) NOT NULL DEFAULT NOW(6);
50	
51ALTER TABLE my_table MODIFY created datetime(6) NOT NULL DEFAULT NOW();
52	
53INSERT INTO Yourtable (Field1, YourDateField) VALUES('val1', (select now()))
54	
55ALTER TABLE `table_name` MODIFY `column_name` datetime NOT NULL DEFAULT NOW();
56	
57INSERT INTO Yourtable (Field1, YourDateField) VALUES('val1', (select now()))