Answer / prasanna shejwal

TIMESTAMP DEFAULT :- when new row get inserted or existing
row get updated that time current timestamp get inserted.

CURRENT_TIMESTAMP :- when row get inserted that time current
timestamp get inserted. No change on update.

ON UPDATE CURRENT_TIMESTAMP :- when row get updated that
time current timestamp get inserted. On inserted default
value get inserted

Answer / amith

The column exhibits the same behavior as a single timestamp
column in a table with no other timestamp columns.

Why do we use views instead of tables?

0 Answers  

---

What are the advantages of myisam over innodb?

0 Answers  

---

What is index length in mysql?

0 Answers  

---

Is mysql from oracle?

0 Answers  

---

how you will Create a database on the mysql server with unix shell.

0 Answers  

---

What are Heap tables?

1 Answers  

---

What is mysql and why it is used?

0 Answers  

---

What is mysql slow query?

0 Answers  

---

What is orm in mysql?

0 Answers  

---

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  

---

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

---

What is dbms in mysql?

0 Answers  

---