if we give update table_name set column_name= default.
what will happen?
Answer Posted / meher
If any default value have been declare to that column when
creating the table then the defaul value will be updated.
Otherwise the column will be update by NULL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are all the different types of indexes? : Sql dba
What is file based approach?
how to create a new table in mysql? : Sql dba
What is sql performance tuning?
How do temporal tables work?
define sql delete statement ? : Sql dba
explain the difference between bool, tinyint and bit. : Sql dba
What is basic structure of pl sql?
What are different functions in sql?
what is timestamp in mysql? : Sql dba
What are the set operators in sql?
What is equi join in sql?
What is the use of & in pl sql?
What is row_number () in sql?
Can we insert delete data in view?