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

How do I change the max connections in mysql?

825

How do I install mysql on windows 7?

934

How do I quit mysql?

866

What is unsigned in mysql?

864

How to create a test table in your mysql server?

972

What are the method you will follow while sql installing

2311

What are the non-standard sql commands supported by 'mysql'?

920

How would concatenate strings in mysql?

945

How to determine the location of the data directory?

903

How do I rename a table in mysql workbench?

902

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

861

Explain the different types of constraints?

882

What happens if null values are involved in expressions?

973

In mysql, what is joins? Explain

910

How to delete an existing column in a table?

883