Question

what is default value? How do you define it? What is the default value of column for which no default value is define?​

Answer 1

Answer:

For date and time types other than TIMESTAMP, the default is the appropriate “zero” value for the type. For the first TIMESTAMP column in a table, the default value is the current date and time. ... For string types other than ENUM, the default value is the empty string.

Explanation:

please mark me as brainlist

Answer 2

Answer:

SEE DOWN

Explanation:

For data entry for a NOT NULL column that has no explicit DEFAULT clause, if an INSERT or REPLACE statement includes no value for the column, or an UPDATE statement sets the column to NULL, MySQL handles the column according to the SQL mode in effect at the time:

For data entry for a NOT NULL column that has no explicit DEFAULT clause, if an INSERT or REPLACE statement includes no value for the column, or an UPDATE statement sets the column to NULL, MySQL handles the column according to the SQL mode in effect at the time:If strict SQL mode is not enabled, MySQL sets the column to the implicit default value for the column data type.

For data entry for a NOT NULL column that has no explicit DEFAULT clause, if an INSERT or REPLACE statement includes no value for the column, or an UPDATE statement sets the column to NULL, MySQL handles the column according to the SQL mode in effect at the time:If strict SQL mode is not enabled, MySQL sets the column to the implicit default value for the column data type.If strict mode is enabled, an error occurs for transactional tables and the statement is rolled back. For nontransactional tables, an

For data entry for a NOT NULL column that has no explicit DEFAULT clause, if an INSERT or REPLACE statement includes no value for the column, or an UPDATE statement sets the column to NULL, MySQL handles the column according to the SQL mode in effect at the time:If strict SQL mode is not enabled, MySQL sets the column to the implicit default value for the column data type.If strict mode is enabled, an error occurs for transactional tables and the statement is rolled back. For nontransactional tables, anerror occurs, but if this hafault is the appropriate “zero” value for the type. For the first TIMESTAMP column in a table, the default value is the current date and time. See Section 10.3,ohh