if you gave a default value for that column then it takes that default v

if we give update table_name set column_name= default.
what will happen?

Question Posted / akki julak

Answer Posted / akki julak

if you gave a default value for that column

then it takes that default value

otherwise it takes NULL

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

does sql support programming? : Sql dba

990

What are different joins used in sql?

1008

How do I order by ascending in sql?

957

how to start mysql server? : Sql dba

1142

How to find 3rd highest salary of an employee from the employee table in sql?

1035

What is trigger and types?

965

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

901

Why is stored procedure faster than query?

907

What is full join in sql?

938

what are integrity rules?

964

What are all the different normalizations?

970

Which one is better subquery or joins?

1008

How to get help at the sql prompt?

1053

Is nosql faster than sql?

970

Cite the differences between execution of triggers and stored procedures?

1028