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

How do you take the union of two tables in sql?

954

What is pl sql record in oracle?

983

What is your daily office routine?

2231

What is composite data type in pl sql?

1052

What is meant by truncate in sql?

1024

How can we avoid duplicating records in a query?

942

How do I save a stored procedure?

964

how do you know the version of your mysql server? : Sql dba

957

what is sub-query? : Transact sql

1059

What is a sql schema used for?

1056

Does truncate free space?

957

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

987

What is difference between primary and secondary key?

989

What is the difference between view and stored procedure?

923

What are the advantages of normalization?

1049