What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?
Answer / amith
On initialization places a zero in that column, on future
updates puts the current value of the timestamp in.
Is This Answer Correct ? | 4 Yes | 0 No |
Is postgresql better than mysql?
What is difference between microsoft sql and mysql?
What are the differences between binary and varbinary?
SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details
What is database url for mysql?
What is the current root password of mysql?
How can you retrieve a particular number of records from a table?
How do you rename a table in mysql?
How do you kill a long running query in mysql?
Can't connect mysql server on localhost?
Where is the mysql database stored?
Which is better mysql or mssql?