What happens if a table has one column defined as TIMESTAMP?

Answer Posted / amith

That field gets the current timestamp whenever the row gets
altered.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I see connections in mysql?

475


What is the maximum number of columns per table?

485


What is save point in mysql?

514


Does mysql automatically index foreign keys?

487


Is mysql a backend?

514






How do I install the latest mysql on ubuntu?

489


What is the difference between is null & is not null?

518


How to delete a database from mysql server.

516


Is blocked because of many connection errors unblock with mysqladmin flush hosts?

498


How do I copy a table in mysql workbench?

452


Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

496


How does mysql store dates?

488


What is InnoDB?

562


What is the maximum size of mysql database?

483


Is mysql free for commercial use?

470