if we give update table_name set column_name= default.
what will happen?
Answer Posted / mano chinna
It Will update NULL to the column. In SQL, while
inserting and updating if you are assigning a column value
as DEFAULT keyword without single or doubled quote it will
take NULL automatically.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between sql and mysql.
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is dcl in sql?
What are local and global Indexes and where they are useful.
Why is normalization important?
What is scalar and vector?
What are all the ddl commands?
How do I view stored procedures?
What is the purpose of the sql select top clause?
what is the difference between nested subquery and correlated subquery?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Does sql backup shrink transaction log?
What do you understand by pl/sql cursors?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
How to rename a table?