A default value is used on initialization, a current timestamp is inserte

Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP.

Question Posted / amith

Answer Posted / amith

A default value is used on initialization, a current
timestamp is inserted on update of the row.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between char and varchar in mysql?

1191

What's the latest version of mysql?

1019

can you tell how can you display the maximum salary in sql? : Mysql dba

920

What is difference between mysql and mysql server?

1034

How to convert character strings to dates?

1140

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

967

Write a command to list all databases in mysql?

1080

What do you need to connect php to mysql?

1035

How do I change the max connection in mysql?

1007

What is heap table in mysql?

1010

How do I assign a variable in mysql?

1050

What is bigint in mysql?

971

What are aggregate functions in mysql?

1431

What is general log in mysql?

1032

How to write optimized query in mysql?

1033