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
Explain what is sql?
What are crud methods?
Does inner join remove duplicates?
what is 'mysqldump'? : Sql dba
define data blocks ? : Sql dba
Is sql difficult?
Why do we use cursors?
How to get help at the sql prompt?
What are the different types of joins in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How do I create a sql script?
Can we call stored procedure in function?
How do you run a query?
How do I write a sql query in pgadmin 4?
What is difference between inner join and self join?