Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain what is sql?

1114


What are crud methods?

1036


Does inner join remove duplicates?

940


what is 'mysqldump'? : Sql dba

1108


define data blocks ? : Sql dba

995


Is sql difficult?

1158


Why do we use cursors?

988


How to get help at the sql prompt?

1113


What are the different types of joins in sql?

1790


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

1038


How do I create a sql script?

1100


Can we call stored procedure in function?

957


How do you run a query?

989


How do I write a sql query in pgadmin 4?

982


What is difference between inner join and self join?

1084