Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP.
Answer / 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 |
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
what is database white box testing? : Mysql dba
What is the purpose of using ifnull() function?
What is mysql vs sql?
How is mysql database stored?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
What are the mysql database files stored in system ?
How can you import tables from a sql file into a database by using the mysql client?
What are the difference between mongodb and mysql?
How triggers can be used in mysql?
Explain the different types of mysql joins.
What are the purposes of using enum and set data types?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)