MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

TIMESTAMP column is updated with Zero value when the table is created. UPDATE CURRENT_TIMESTAMP modifier updates the timestamp field to the current time whenever there is a change in other fields of the table.

ALTER TABLE <tablename>
CHANGE column_name <columnname> TIMESTAMP NOT NULL 
DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

 




Next 5 interview question(s)

1
What are the drivers in MySQL?
2
What storage engines are used in MySQL?
3
Give string types available for column?
4
Difference between CHAR and VARCHAR?
5
What are the advantages of MySQL when compared with Oracle?